-
Junior Member
Grant
Hi,
How can we grant full permissions to user on any database in sql?
Regards,
Radhi.
-
Junior Member
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???????????
Last edited by kalayama; 02-22-2007 at 08:03 AM.
Reason: Be patient; Don't post too many posts without any replies to your previous post
-
Junior Member
Re: Grant
Hi Shivender,
ya i rather got it solved.
I used roles to do it.
thanks for the concern
Regards,
Radhi.
-
Junior Member
Re: Grant
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 ;
-
Junior Member
Re: Grant
login as sys, system
grant sysdba to user
-
Re: Grant
You may not grant SYSDBA from system schema. Better to login as SYS instead.
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