Not able to grant a role
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Not able to grant a role

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    Not able to grant a role

    Hi!
    I am not able to grant a role to another user. I am able the see the existing role in dba_role_privs,role_sys_privs.I cannot see the same role in role_role_privs,
    ORA-01919


    Many Thanks,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    put the text if your error message, most people dont know the error messages.

    Do you have permissions to grant the role to another person?

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Was the role created with ADMIN option enabling you to grant it to someone else?

  4. #4
    Join Date
    Jan 2003
    Posts
    141
    Hi,
    Fixed the problem...the role was created without admin option. Thanks for your valuable suggestions.

    Many Thanks,

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