Showing posts with label privileges. Show all posts
Showing posts with label privileges. Show all posts
Friday, January 15, 2021

What privileges are needed for flashback queries?

›
If the table is in your own schema, no extra privileges are needed. If the table is in a schema different from your own, you need object ...
Tuesday, February 12, 2019

How to solve ORA-01031: insufficient privileges when creating a cross-schema fk constraint

›
Scenario: you want to create a cross-schema Foreign key constraint: ALTER TABLE JIM.TRANSACTION ADD ( CONSTRAINT TRANSACTION_FK ...
Friday, February 1, 2019

How to create a trigger that will add newly created tables to a role

›
A commonly asked for functionality in my day-to-day work is READ-ONLY access for users to various tables in the database. This is easy to s...
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...
Thursday, January 11, 2018

How to bulk-grant privileges to a selection of users using PL/SQL

›
This anonymous PL/SQL script will select all the desired users, and then grant SELECT on a number of performance views to these. set serve...
Wednesday, August 9, 2017

How to use the 12c Privilege Analysis feature

›
One of the many New features in Oracle 12c is the ability to perform analysis of privileges that are assigned to a user. Privilege Analys...
Thursday, February 23, 2017

What is the INHERIT PRIVILEGES granted to PUBLIC in 12c?

›
I was checking which object privileges my user had made, and I found the following: select * from user_tab_privs_made; GRANTEE TA...
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...