If I get to SQL*Plus and type:
SET ROLE ALL EXCEPT R1;
SELECT * FROM SESSION_ROLES;
I see I have all except R1. But if I execute the following:
create or replace procedure ds as
cur := dbms_sql.open_cursor;
dbms_sql.parse (cur,'set role all except R1',dbms_sql.v7);
tmp := dbms_sql.execute(cur);
I get no error messages yet the R1 role is still in my privilege domain.
What did I miss ?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…