I was reviewing some features in Oracle and, basically, every single time I review them I find something new. Seems Oracle Databases’ features are near to infinite and we frequently find some that can really add value to our solutions.
So I decided to make a serie of posts with really quick notes about some of them.
You can see all posts in this serie in my page of posts and some others more.
Ready? Here it goes, today actually 2 small things:
Execute Grant on Directories
In 10g was possible to grant READ and/or WRITE, but this also allowed executing the ORACLE_LOADER access driver. In 11g, only a user that has been given EXECUTE access to the directory object is allowed to run programs in it. This should be granted using:
grant EXECUTE on DIR_EXAMPLE;
DATABASE_ROLE constant for SYS_CONTEXT
In 11g the context procedure can also give DATABASE_ROLE, as it might be used as check for certain procedures to run only on standbys or to avoid it, for example.
Between values are: PRIMARY, PHYSICAL STANDBY, LOGICAL STANDBY and SNAPSHOT STANDBY. This can be executed this way:
SELECT sys_context('USERENV', 'DATABASE_ROLE') FROM dual;
You probably know about that, right?
Anyway, always good to remember!