Help in granting privileges to a role and assiging this role to a user

Dear oracle gurus,

I have created a procedure that does the following

1. checks if a role "my_role" exists and if not creates the role
2. It grants create session privilege to this role with admin option
3. I am doing a select grant on objects of type VIEW and owned by <A_OWNER> select Object_name form all_objects where owner='A_OWNER' and object_type='VIEW'; grant select on <A_OWNER>.object_name to <my_role>

This procedure is executed as <A_OWNER> himself.

Inside my java code, i grant this role "my_role" to a user.

However, the first 2 seems to have taken into affect but the 3 select grant does not seem to take into affect

-any help,
thanks,
avsrk Received on Wed Jul 23 2003 - 16:05:08 CDT