Skip To Main Content
Grant Role on Muck Rack

Grant Role

As seen in: Fix This, CSDN, itpub.net
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to Grant Role’s profile

Articles by Grant Role

open Gauss 数据库-06 openGauss数据库安全指导手册5.0.0

|
By Grant Role
| CSDN
发文章是为了证明自己真的掌握了一个知识，同时给他人带来帮助，如有问题，欢迎指正，祝大家万事胜意！ 目录 前言 1.2 用户 1.3 角色 1.4 Schema 2 审计 前言 本实验主要内容为操作系统参数检查、 openGauss 健康状态检查、数据库性能检查、日志检查 和清理、时间一致性检查、应用连接数检查、例行维护表等 我的环境： 设备名称 设备型号 软件版本 虚拟机 VMware VMware-workstation-full-17.5.1 操作系统 openEuler openEuler 22.3LTS 数据库 openGauss openGauss 5.0.0 需要的工具，大家不用现在下，后面用到了再下也可以，如果需要相关文件，可以评论，其实大多数都是可以去官网下的哈，因为我只能通过网盘给大家，文件又有点大，网盘的速度大家都是清楚的哈哈，所以还是推荐大家去官网，如果实在找不到可以找我 openGauss数据库安全指导 1.1 实验介绍 1.1.1 关于本实验 本实验主要描述用户的创建管理、角色的创建管理、 Schema 的创建管理、用户权限设置、用 户安全策略设置。...
Open in Who Shared Issue with article?

Configure Kerberos authentication for Amazon RDS for PostgreSQL without joining an Active Directory domain | Amazon Web Services

|
By Grant Role
| Amazon Web Services (AWS)
Organizations that adopt centralized authentication mechanisms gain the following benefits: Enhanced security posture: Centralized authentication enables quick addition or removal of user access throughout the network, giving organizations improved security and the ability to respond quickly to security threats. Scalability: By controlling access through a centralized database, organizations can scale their network and minimize performance issues.
Open in Who Shared Issue with article?

LightDB 23.1兼容Oracle新特性支持

|
By Grant Role
| itpub.net
首页 > 数据库 > PostgreSQL > LightDB 23.1兼容Oracle新特性支持 22.3中LightDB兼容Oracle语法做了增强 新特性兼容如下： grant connect/resource语句 drop user test cascade; grant connect/resource语句 如下语句在LightDB中可以运行成功 切换到Oracle模式的数据库test中执行,执行下面语句确认 show lightdb_dblevel_syntax_compatible_type; Oracle 返回Oracle说明数据库库Oracle模式 lightdb@test=# CREATE USER TEST IDENTIFIED BY test DEFAULT TABLESPACE test TEMPORARY TABLESPACE test; CREATE ROLElightdb@test=# GRANT CONNECT TO TEST;GRANT ROLElightdb@test=# GRANT RESOURCE TO TEST;GRANT...
Open in Who Shared Issue with article?

Modernizing Java Apps and Data on Azure Part Two: Migrating Data

|
By Jeff Griffith, Create Database, Grant Role
| The Code Project
This is Part 2 of a 6-part series that demonstrates how to take a monolithic Java application and gradually modernize both the application and its data using Azure tools and services. This article shows how to set up an Azure PostgreSQL database, migrate the app’s data over, and ensure the application still works. You will also see that the app runs locally while connected to the Azure Postgres database instead of the local database. This article is a sponsored article.
Open in Who Shared Issue with article?

Working with Trusted Language Extensions for PostgreSQL

|
By Grant Role, Grant Usage, Grant Execute
| Fix This
Trusted Language Extensions for PostgreSQL is an open source development kit for building PostgreSQL extensions. It allows you to build high performance PostgreSQL extensions and safely run them on your RDS for PostgreSQL DB instance. By using Trusted Language Extensions (TLE) for PostgreSQL, you can create PostgreSQL extensions that follow the documented approach for extending PostgreSQL functionality.
Open in Who Shared Issue with article?

PostgreSQL-16新特性之普通用户的保留连接个数（reserved_connections）_ITPUB博客

|
By Pg Ace, Grant Role
| itpub.net
PostgreSQL数据库为了保证在高并发，高连接数情况下某些用户能够正常连接到数据库里，设立了几个用户连接的保留个数。 本文介绍了PostgreSQL16版本前为超级用户保留的连接数（superuser_reserved_connections）以及PostgreSQL16版本新增的为普通用户的保留的连接数（reserved_connections）。 PostgreSQL数据库里最大的连接数由max_connections控制。通常情况下，用户可以使用的连接数不可以超过这个设置。 最初对于数据库而言，如果会话的释放机制不够合理，没有采用连接池，又恰巧不巧地赶上了业务高峰期，大量并发的情形，是比较棘手的。因为就算我想暂时释放掉部分连接。可能也没有了空余的连接数供我们连接到数据库里进行这番操作。 因此PostgreSQL数据库在7.4版本就为数据库增加了一个superuser_reserved_connections参数，指定为超级用户保留的连接数。这样，当遇到了大量并发连接，甚至不停有新连接产生的时候。我们可以使用超级用户通过这几个保留的连接，进到数据库里，进行一些分析和处理。...
Open in Who Shared Issue with article?
Show More