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

Thread: Required System Priveleges

  1. #1
    Join Date
    Feb 2001
    Posts
    16
    Hi there friends,

    Does anyone know what SYSTEM PRIVELEGES are required when granting the following OBJECT PRIVELEGES?

    GRANT INSERT ON "ACCOUNTS"."ACCOUNT" TO "T1"
    GRANT SELECT ON "ACCOUNTS"."ACCOUNT" TO "T1"
    GRANT UPDATE ON "ACCOUNTS"."ACCOUNT" TO "T1"

    ACCOUNT is the table I want rights to in the ACCOUNTS tablespace, but I also need to grant some SYSTEM PRIVELEGES before the OBJECT PRIVELEGES stick.

    I'm not sure which ones.

    Does anyone know, please?

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    There is no system privilige to grant object privileges. The owner of an object can grant object privileges, and the user or role granted the object privilege with grant option van grant object privileges.

    If you grant privileges on a table you cannot specify the tablespace, but you can specify the schema. With
    GRANT select ON accounts.account TO t1;
    you grant select privilege on table account in schema accounts to user or role t1.

    With
    GRANT select ON accounts.account TO t1 WITH GRANT OPTION;
    T1 is able to grant select on the table to other users or roles.



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