dbms_system package

Hi simply_dba
Thanks for discussion
i was on the wrong foot,it was a big mistake ,some time when you start wrong ,u continue on that some time....it's better to realise...as an experienced dba i should not make this mistake
any way ...
while working in office it suddenly comes into my mind .....
opps ! i was working as a SYSTEM user
Regards
waiting for ur comments on that ---dont over react pl
Bi

Quote:

---

opps ! i was working as a SYSTEM user

---

So What ? dbms_system should still be accessible.
SYSTEM has execute permission on dbms_system.

Hi simply_dba

By default system hasnt got access to dbms_system. At least in 9i.

SYSTEM does not have execute priviledges on dbms_system by default. That's correct.

yes it does !!
here is an example

Quote:

---

SQL> create user asdf identified by asdf;

User created.

SQL> grant dba to asdf
2 ;

Grant succeeded.

SQL> disco
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> connect asdf/asdf@qa2
Connected.
SQL> exec dbms_system.set_sql_trace_in_session(140,888,TRUE);

PL/SQL procedure successfully completed.

---

As system user has dba role by default, it has execute privilege on dbms_system by default

Are you sure you have not explicitely granted execute on DBMS_SYSTEM to DBA?
Sorry but I'm pretty sure that it does not, and the pando's experience confirms that

why don't you try it out yourself?
It's better than explicitly believing others.

https://metalink.oracle.com/metalink...,1,1,helvetica
Metalink Note 100883.1
NB: Unlike other packages created by catproc.sql, a public synonym is not
created for DBMS_SYSTEM and no privileges on the package are granted.
Thus, as initially created, only SYS can reference and use any component
in the DBMS_SYSTEM package.

SYS can grant access to DBMS_SYSTEM components to any user/role:

Example: GRANT EXECUTE ON DBMS_SYSTEM to ;

Should I Try something more?
I have tried that many times and I know for sure that it IS NOT granted to DBA by default as PANDO said

Regards
Boris

Quote:

---

Originally Posted by simply_dba

yes it does !!
here is an example


As system user has dba role by default, it has execute privilege on dbms_system by default

---

Check this and look for grantee, either system has been given execute privelge directly or indirectly through roles or so..

{select * from dba_tab_privs where table_name = 'DBMS_SYSTEM';}