GRANT

!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

Sorry :

It is not posted correctly : It should be like

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

Quote:

---

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

Quote:

---

Originally posted by aarroyob

Quote:

---

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