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

Thread: ROLES

  1. #1
    Join Date
    Mar 2002
    Posts
    5
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Posts
    221
    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.
    Santosh Jadhav
    8i OCP DBA

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