Grant on emp table not working.......
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Grant on emp table not working.......

  1. #1
    Join Date
    Oct 2000
    Posts
    28
    Hello,
    How I can grant object privileges to users......????

    Following are my activities....

    SVRMGR>connect internal;
    connected....
    SVRMGR>grant select on scott.emp to sunil.
    (here sunil is the name of user....)
    *
    ORA-01031 : Insufficient privileges

    What is wrong. Why I am not able to give select privileges on scott.emp table to user sunil. What is this insufficient privilege to internal user......


    Sunil

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Retry it. If you are logging in as SYS, there should be no reason for this error. Retry by logging in as SYS or SYSTEM.

  3. #3
    Join Date
    Nov 2000
    Posts
    7

    Smile

    Hi

    You login as scott and try to grant the object priviledge. This command won't fail.




  4. #4
    Join Date
    Oct 2000
    Posts
    28
    If I logged in as scott, I am able to give object privileges of scott user to another user 'sunil' but I am not able to grant same privilege by connecting as sys,system,internal or as sysdba....what is wrong....how to debug....
    Sunil

  5. #5
    Join Date
    Aug 2000
    Posts
    87
    Hi sbhujbal,
    U see since emp table is owned by scott, only scott can grant object privilages to other users.Even to Sys or System to Select on the object of scott.Not even sys,system,internal can do this,thought they have DBA Privilages.

    Cheers,
    Vinod Kumar.

  6. #6
    Join Date
    Oct 2000
    Posts
    28
    Vinod,
    But I connected as connect dba/password as sysdba in server manager and executed same command
    grant select on scott.emp to sunil ......and it says insufficient privileges.

    DBA should have all privileges to grant one users schema object to another user..........why owner has to explicitly grant that permission to another user.....
    Can you clarify how it works.....because I am thinking that DBA can grant any schema.object permission to another user ...because he is having grant any privilege permission...

    Sunil

  7. #7
    Join Date
    May 2000
    Location
    Alex, Egypt
    Posts
    41
    There is two types of privs:
    object privs and system privs.
    user sys can grant any system privs,even with the admin option, which means that the grantee can again grant it to other users.

    regarding the object privs the user sys has all privs. on them but without the ability to grant privs to other users,
    the owner user should grant these privs, to other users or to the sys user with the admin option, so he can grant it to other users.
    Amir Magdy

  8. #8
    Join Date
    Oct 2000
    Posts
    28
    Thanks.
    I understood that "sys" cannot grant object privileges of one user to another. Only that user can grant them to another user or he has to grant to sys with admin option.

    Sunil

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