-
Hi,
This is what i want to do:
Create a role that have all permissions to some objects and when i will grant this role to an user, that user must me abble to manage all permissions of those objects and giving or revoking those same permissions.
Basicly create a role that manage all objects and when i grant that role the users must be abble to manage teh objects too.
How can i do such thing?
thanks,
Paulo
-
-
u urself have given the answer Paulo.
First of create the role using CREATE ROLE statement. then grant the object privileges to the user with GRANT OPTION.