DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Privileges

  1. 04-02-2003, 11:46 PM #1
    cravi
    cravi is offline Member
    Join Date
    Nov 2000
    Posts
    157

    Privileges

    Hi Can you please give me a QUERY for :

    people that have back end access to production and the privileges they have!!

    Thanks,
    Ravi
    ravi
    Reply With Quote Reply With Quote
  2. 04-03-2003, 01:51 AM #2
    alapps
    alapps is offline Member
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    What is "Back end access to production"?
    alapps

    Fast, Cheap, Reliable... Pick Two(2)
    Reply With Quote Reply With Quote
  3. 04-03-2003, 04:04 AM #3
    cravi
    cravi is offline Member
    Join Date
    Nov 2000
    Posts
    157
    I mean to check all the users whoever is having dba privileges to the database.
    ravi
    Reply With Quote Reply With Quote
  4. 04-03-2003, 04:42 AM #4
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Code:
     SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'DBA'
    HTH.
    Reply With Quote Reply With Quote
  5. 04-03-2003, 05:02 AM #5
    cravi
    cravi is offline Member
    Join Date
    Nov 2000
    Posts
    157
    Hi

    This query gives all the GRANTEES whoever is having DBA PRIVS.

    But i want all the users whoever granted DBA privileges.

    Thanks
    ravi
    Reply With Quote Reply With Quote
  6. 04-03-2003, 05:07 AM #6
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by cravi
    But i want all the users whoever granted DBA privileges.
    All those who have 'admin_option' as yes could have granted it to others.
    Reply With Quote Reply With Quote
  7. 04-03-2003, 05:21 AM #7
    cravi
    cravi is offline Member
    Join Date
    Nov 2000
    Posts
    157
    Hi

    This query gives all the GRANTEES whoever is having DBA PRIVS.

    But i want all the users whoever granted DBA privileges.

    Thanks
    ravi
    Reply With Quote Reply With Quote
  8. 04-03-2003, 06:03 AM #8
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by cravi
    But i want all the users whoever granted DBA privileges.
    Can you make up your mind what you realy want? This certanly is not what you have asked initialy.

    And BTW, ggnanaraj have allready given you the answer for this question, so why are you repeting it?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width