Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2010
    Posts
    5

    Unanswered: Grantee and username

    Hi, checking the column GRANTEE of SYS.DBA_SYS_PRIVS and comparing it to the one called USERNAME in SYS.DBA_USERS found that several GRANTEES are not mentioned at the DBA_USERS. Is it normal????

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    so what is listed below?

    Code:
      1  select grantee from dba_sys_privs
      2  minus
      3* select username from dba_users
    SQL> /
    
    GRANTEE
    ------------------------------
    AQ_ADMINISTRATOR_ROLE
    CONNECT
    DATAPUMP_EXP_FULL_DATABASE
    DATAPUMP_IMP_FULL_DATABASE
    DBA
    EXP_FULL_DATABASE
    IMP_FULL_DATABASE
    JAVADEBUGPRIV
    LOGSTDBY_ADMINISTRATOR
    MGMT_USER
    OEM_ADVISOR
    OEM_MONITOR
    OLAP_DBA
    OLAP_USER
    OWB$CLIENT
    RECOVERY_CATALOG_OWNER
    RESOURCE
    SCHEDULER_ADMIN
    TEST_ROLE
    
    19 rows selected.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2010
    Posts
    5
    I see several system users/roles; but in my case I found normal user acounts like RSMITH for example..

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I see several system users
    REALLY?
    Which users?
    post proof

    >roles;
    OK

    >>but in my case I found normal user acounts like RSMITH for example..
    REALLY?
    post proof

    post results from my SQL above

    I don't know what you have.
    I don't know what you do.
    I don't know what you see.
    It is really, really, REALLY difficult to fix a problem that can not be seen.
    use COPY & PASTE so we can see what you do & how Oracle responds.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2010
    Posts
    5
    I prefere not to show examples; the fact is that GRANTEE shows a large list of normal users that I can't find in the USERNAME column of sys.dba_users.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    My crystal ball is broken so enjoy your mystery.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    When you drop a user, privileges that were explicitly granted to that user do not automatically disappear; you have to revoke them.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by n_i View Post
    When you drop a user, privileges that were explicitly granted to that user do not automatically disappear; you have to revoke them.
    REALLY?

    SQL> select grantee from DBA_SYS_PRIVS where grantee like 'USER%';

    GRANTEE
    ------------------------------
    USER1
    USER1
    USER1
    SQL> connect oe/oe
    Connected.
    SQL> select table_name from user_tables;

    TABLE_NAME
    ------------------------------
    PRODUCT_REF_LIST_NESTEDTAB
    SUBCATEGORY_REF_LIST_NESTEDTAB
    CUSTOMERS
    PRODUCT_DESCRIPTIONS
    PROMOTIONS
    ORDER_ITEMS
    PRODUCT_INFORMATION
    ORDERS
    INVENTORIES
    WAREHOUSES

    10 rows selected.

    SQL> grant select on orders to user1;

    Grant succeeded.

    SQL> connect / as sysdba
    Connected.
    SQL> drop user user1 cascade;

    User dropped.

    SQL> select grantee from DBA_SYS_PRIVS where grantee like 'USER%';

    no rows selected

    SQL>
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by anacedent View Post
    REALLY?
    No, you're right - I spoke too soon.

Posting Permissions

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