-
!HELLO
I come to here that
we can create user and grant privilege in one single statement is there is any command like that.
-
Try this:
grant connect,resource,[DBA] to Identified by
Nagesh
-
Sorry :
It is not posted correctly : It should be like
grant connect,resource,dba to username identified by pwd;
Nagesh
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|