471,073 Members | 1,362 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

user authorazation

Hi,
I confuse. I had a role named lsc_role with certain object privs. if i
run this query :
select role from dba_role;

ROLE
-----------------------
JAVADEBUGPRIV
EJBCLIENT
JAVA_ADMIN
JAVA_DEPLOY
CTXAPP
XDBADMIN
AUTHENTICATEDUSER
LBAC_DBA
OLAP_DBA
SALES_HISTORY_ROLE
LSC_ROLE

i can see the role exists. but when i try to see the object privs
granted to lsc_role with this query :

SQLselect *
2 From role_tab_privs
3 where role = 'LSC_ROLE';

no rows selected
User who granted LSC_ROLE is still working, mean access is restricted
as what was assigned to this role.

Why i can see the object privs assigned to them in second query?

I granted the role lsc_role to user using id: abc who has dba role.

I wonder is that only grantor can see grantees? Hm.. means, id dba_1
created and granted role_a to user b. When dba_2 run tthis query:
SQLselect *
2 From role_tab_privs
3 where role = 'role_a';
dba_2 will see nothing, am I right?

In this case, which userid is better when dba want to create or
granted a role or role; using a his own id or conn as sysdba?

more confuse now!!

thanz.

regard,
lclim
Jun 27 '08 #1
0 679

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by leecho | last post: by
60 posts views Thread by Fotios | last post: by
3 posts views Thread by zlst | last post: by
6 posts views Thread by martin | last post: by
2 posts views Thread by rn5a | last post: by
1 post views Thread by Carlettus | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.