Hi,
How can we grant full permissions to user on any database in sql?
Regards,
Radhi.
Printable View
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.