Showing posts with label Roles. Show all posts
Showing posts with label Roles. Show all posts
Thursday, June 5, 2025

create user in postgres - basic syntax

›
I will create a group role called common_users a user called ro_user1 in a database called db01 The read-only user ro_user1 should ...
Wednesday, September 4, 2019

How to create a proxy authenticated user in Oracle

›
Create a general user for authentication: CREATE USER APP_POOL IDENTIFIED BY app_pool_users123 DEFAULT TABLESPACE USERS TEMPORARY TABL...
Wednesday, November 28, 2018

Changes in privilege "SELECT ANY DICTIONARY" in Oracle 12c

›
From version 12.1 and onwards, Oracle has introduced some changes to enhance security when granting the system privilege "SELECT ANY D...
Tuesday, July 12, 2016

Overview of role privileges

›
The following UNION can be handy to get an overview of what system privileges, object privileges and other roles a specific role may contain...

How does Oracle decide which roles should be enabled in a session?

›
Oracle uses the concept of default roles to decide whether or not a role should be enabled when a user establishes a session. CREATE USER ...
Monday, January 12, 2015

Getting ORA-01031: insufficient privileges when data dictionary table is being used in a view

›
I must admit I have been consulted in these situations before, but since then I had forgotten how it worked and failed to take notes on how ...
Wednesday, October 15, 2014

Why aren't other schemas' procedures showing in TOADs schema browser?

›
Problem: User SCOTT has been granted SELECT on a number of tables belonging to another schema, OBM. They all show up neatly in TOADs schema...
Friday, November 1, 2013

Can you revoke all object privileges from a role in one go?

›
Answer: No. The closest shortcut you get is to revoke all privileges per object from a role. Example: REVOKE ALL ON SCOTT.T1 FROM TEST...