GRANT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: GRANT

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Cool

    !HELLO

    I come to here that

    we can create user and grant privilege in one single statement is there is any command like that.





  2. #2
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Try this:

    grant connect,resource,[DBA] to Identified by

    Nagesh

  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Sorry :

    It is not posted correctly : It should be like

    grant connect,resource,dba to username identified by pwd;
    Nagesh

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by gnagesh
    Sorry :

    It is not posted correctly : It should be like

    grant connect,resource,dba to username identified by pwd;
    Anyway it is not possible to create a user and grant privilegies to it in the same statement.

    You should first create the user and after grant it all the priveligies you want.

    Regards

    Angel

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by aarroyob
    Originally posted by gnagesh
    Sorry :

    It is not posted correctly : It should be like

    grant connect,resource,dba to username identified by pwd;
    Anyway it is not possible to create a user and grant privilegies to it in the same statement.

    You should first create the user and after grant it all the priveligies you want.

    Regards

    Angel
    My apologizes, i havenīt read correctly. It works

    Regards

    Angel

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