DBsGuru June 3, 2021 0 Comments

How to Grant READ ONLY Access on Schema Using ROLE in Oracle 0 (0)

How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application schema. To fulfill this request either we can grant SELECT privileges on all tables to requestor which are owned by specific application schema or create […]

 96 Total Views,  3 Views Today

Spread the Knowledge!

READ MORE
Jamsher Khan May 19, 2021 0 Comments

Create, Drop, Alter Roles in PostgreSQL 0 (0)

Create, Drop, Alter Roles in PostgreSQL PostgreSQL represents accounts as roles. PostgreSQL uses roles to represent user accounts. It doesn’t use the user concept like other database systems Oracle & MySql. Roles that can log in are called login roles. When roles contain other roles, they are called group roles. When you create a role, […]

 168 Total Views,  12 Views Today

Spread the Knowledge!

READ MORE