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

Thread: privileges do not work through roles

  1. #1
    Join Date
    Aug 2002
    Posts
    8

    Hi

    I have created role role_A and granted select any table system privileges to role_A. I have also created user A.
    I grant the role_A to user A. However, when I login to user A I could not select any tables. What's wrong here? Is there a scrip I need to run to enable this feature. It seems like all of the privileges I grant through a role do not work. I have to specifically grant privileges to user.

    Please help! Thanks,

    YM

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Just a hunch if you are using pl/sql to select any table then the grant needs to be an explicit grant of the privilege to the user. Otherwise, I'm not sure what the issue is.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I belive your problem is not related to roles, but to synonyms.

    Create synonym you want to select from, or use full name notation:

    SELECT * FROM table_owner.table_name;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Aug 2002
    Posts
    8
    Thanks for the help. gandolf989 reminds me to check it through sql plus. It works there. It just does not work through SQL Navigator. May be some set up in SQL Navigator is not right.

Posting Permissions

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


Click Here to Expand Forum to Full Width