ROLES

[EVERLAST]

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

[marist89]

Sure. See http://technet.oracle.com/docs/produ...intro.htm#8303
http://technet.oracle.com/docs/produ...privs.htm#1131

[sjadhavdba]

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.