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.
grant select_catalog_role to user_name;
for execute you need to give execute priv... to user
Last edited by adewri; 02-28-2003 at 05:48 AM.
"There is a difference between knowing the path and walking the path."
8i - SELECT_CATALOG_ROLE
9i - SELECT ANY DICTIONARY
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width