Script, logoff if not dba
Hi, I'm looking for a script that will check that the user is a DBA before running SYSDBA commands?
i.e.
select SYS_CONTEXT('USERENV','ISDBA') from dual;
when false exit
otherwise
grant x on y to z
...
Before I go around and create a script I was wondering if there was any easy way or Oracle script already in place for this?
James.