Grant

Hi,

How can we grant full permissions to user on any database in sql?
Regards,
Radhi.

hi ridhi,
i think u should try this......

GRANT permission, ...
TO userid, ...

permission :
DBA
| BACKUP
| VALIDATE
| GROUP
| MEMBERSHIP IN GROUP userid, ...
| [ RESOURCE | ALL ]

i m not much sure that will this solves ur problem or not........


is ur problem solved???????????

Hi Shivender,

ya i rather got it solved.
I used roles to do it.
thanks for the concern

Regards,
Radhi.

There are 3 types of roles to grant privileges depending upon requirement
1.Resource
2.Connect
3.DBA

Among these DBA cotains all the privileges,try the following one


sql> Grant DBA to <username>;

login as sys, system
grant sysdba to user

You may not grant SYSDBA from system schema. Better to login as SYS instead.