GRANT

[smdakram]

!HELLO

I come to here that

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

[gnagesh]

Try this:

grant connect,resource,[DBA] to Identified by

[gnagesh]

Sorry :

It is not posted correctly : It should be like

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

[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

[aarroyob]

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