Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> A Security Manager Problem?
Hello,
I created 2 users:TEST and AP_TEST,
and I want to grant TEST's object privileges to AP_TEST.
(ex. grant select on account to AP_TEST;)
I wish to grant object privileges in the security manager....for convenient.
Now I do this for grant DBA role to TEST,login security manager as TEST/pwd. Then grant TEST's object privrluiges to AP_TEST. But with DBA roles,TEST could alter/udpate/insert/delete/select any table. ......I think it's a little bad!
If I grant TEST only CONNECT and RESOURCE roles,login security manager as TEST. I couldn't select on DBA_USERS,ora-01031:insufficient privileges.
If I want to grant TEST's object privileges to AP_TEST in security manager, what privileges should I grant to TEST first?
Really need help.....or I must do the grant command in the SQL*Plus. Thank you for any tips.
Violin.
vioin.hsiao_at_mail.pouchen.com.tw
Received on Thu Feb 04 1999 - 23:50:26 CST