DBA privledges

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.