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?
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.
GRANT select ON accounts.account TO t1 WITH GRANT OPTION;
T1 is able to grant select on the table to other users or roles.