Hello all,
I need to create a user who can select from the dba_ and v$ views. The user also needs to execute some packages. However i do not want to give the user dba privledges. Is there an alternate way of doing this.
Thanks.
Chucks_k
Printable View
Hello all,
I need to create a user who can select from the dba_ and v$ views. The user also needs to execute some packages. However i do not want to give the user dba privledges. Is there an alternate way of doing this.
Thanks.
Chucks_k
grant select_catalog_role to user_name;
for execute you need to give execute priv... to user
8i - SELECT_CATALOG_ROLE
9i - SELECT ANY DICTIONARY
Regards
Thanks all.
That helps.