Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    42

    Unanswered: Grant Option For Roles

    hi,
    i want to create a role, and i used the following syntax.

    create role admin identified by adm;

    and next i want to give some privilleges to that role, i am unable to give the grant option for that role, can any one help me in this matter, pls give me the full syntax of grant and what are the privilleges that you will give a particular role.

    thanking you
    kiran

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    62
    grant <previlege name> to admin; (admin is your role name)
    Regards,

    Rushi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •