Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 5th, 2012, 03:06 PM
Amukherji Amukherji is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2011
Posts: 26 Amukherji User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 23 m 15 sec
Reputation Power: 0
Role, user one doubt..pls help

When i query dba_role_privs, one of the GRANTEE there is 'DBA' which is granted several roles & now when i query dba_users there is no 'DBA' value in column USER there....i understand one would say DBA would be a role in dba_role_privs and not an actual user..but if thats the case then why SYS which is assigned DBA role has some similar roles which are shown assigned to this GRANTEE 'DBA'....also if any user DBA is there why it is not showing up in dba_users...please let me know where am wrong or misunderstood something..or let me know if i need to rephrase my query to make it more clear.....Thanks a lot for help..!

Reply With Quote
  #2  
Old January 5th, 2012, 03:45 PM
LKBrwn_DBA's Avatar
LKBrwn_DBA LKBrwn_DBA is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
 
Join Date: Sep 2006
Posts: 748 LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level)LKBrwn_DBA User rank is Major (30000 - 40000 Reputation Level) 
Time spent in forums: 1 Week 1 h 41 m 3 sec
Reputation Power: 348
Talking

Quote:
Originally Posted by Amukherji
When i query dba_role_privs, one of the GRANTEE there is 'DBA' which is granted several roles & now when i query dba_users there is no 'DBA' value in column USER there....i understand one would say DBA would be a role in dba_role_privs and not an actual user..but if thats the case then why SYS which is assigned DBA role has some similar roles which are shown assigned to this GRANTEE 'DBA'....also if any user DBA is there why it is not showing up in dba_users...please let me know where am wrong or misunderstood something..or let me know if i need to rephrase my query to make it more clear.....Thanks a lot for help..!


DBA is a role.
__________________

Reply With Quote
  #3  
Old January 5th, 2012, 04:03 PM
Amukherji Amukherji is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2011
Posts: 26 Amukherji User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 23 m 15 sec
Reputation Power: 0
Quote:
Originally Posted by LKBrwn_DBA
DBA is a role.



i know, but confused..pls tell me why then SYS is assigned these roles (olap_dba, plustrace,javaadmin,xdbadmin, import, export db etc) again when it has dba role always assigned to it.
pls see this & explain , sorry am confused


SQL> select * from dba_role_privs where grantee = 'DBA';

GRANTEE GRANTED_ROLE
------------------------------ -------------------------
DBA OLAP_DBA
DBA XDBADMIN
DBA PLUSTRACE
DBA JAVA_ADMIN
DBA JAVA_DEPLOY
DBA WM_ADMIN_ROLE
DBA EXP_FULL_DATABASE
DBA IMP_FULL_DATABASE
DBA DELETE_CATALOG_ROLE
DBA SELECT_CATALOG_ROLE
DBA EXECUTE_CATALOG_ROLE



and :-

SQL> select * from dba_role_privs where grantee = 'SYS';

GRANTEE GRANTED_ROLE
------------------------------ ---------------------------
SYS DBA
SYS CTXAPP
SYS WKUSER
SYS CONNECT
SYS OLAP_DBA
SYS RESOURCE
SYS XDBADMIN
SYS EJBCLIENT
SYS PLUSTRACE
SYS JAVAIDPRIV
SYS JAVA_ADMIN

Reply With Quote
  #4  
Old January 6th, 2012, 10:28 AM
magicwand magicwand is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2010
Location: Vienna, Austria
Posts: 58 magicwand User rank is Private First Class (20 - 50 Reputation Level)magicwand User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 10 h 28 m 33 sec
Reputation Power: 4
Amukherji,

that's because (as part of the CREATE ROLE statement) Oracle automatically grants EVERY newly created role (WITH ADMIN OPTION) to SYS

Last edited by magicwand : January 6th, 2012 at 01:17 PM.

Reply With Quote
  #5  
Old January 6th, 2012, 03:15 PM
Amukherji Amukherji is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2011
Posts: 26 Amukherji User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 23 m 15 sec
Reputation Power: 0
Quote:
Originally Posted by magicwand
Amukherji,

that's because (as part of the CREATE ROLE statement) Oracle automatically grants EVERY newly created role (WITH ADMIN OPTION) to SYS


hmm, so in dba_role _privs in GRANTEE column, only DBA is the role which is assigned roles and all other values are users..thanks ...i know this question was stupid but thanks for clearing my doubt..

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Role, user one doubt..pls help

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap