| Granting permission to schema [message #234865] |
Thu, 03 May 2007 06:26  |
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
|
Senior Member |
|
|
Hi,
how can I grant permission to a schema by ADmin login.
I have never granted permission from Admin login.
I have only granted permission to objects in my schema.
Please let me know how to give and revoke permission to other users as a Admin for one or more schema.
Thanks,
Mona
|
|
|
|
| Re: Granting permission to schema [message #234874 is a reply to message #234865] |
Thu, 03 May 2007 06:47  |
saibal
Messages: 111
Registered: March 2007
Location: India
|
Senior Member |
|
|
|
There is no fundamental difference on how you grant/revoke privileges to a user, regardless of how you are connected. Of course, there will be certain levels and/ or classes of privileges that can be given only by a user having the DBA, SYSDBA, or SYSOPER privileges, but at the basic level it's the same.
|
|
|
|
|
|
| Re: Granting permission to schema [message #234886 is a reply to message #234879] |
Thu, 03 May 2007 07:07 |
saibal
Messages: 111
Registered: March 2007
Location: India
|
Senior Member |
|
|
Have a look at the following:
sys@NEWDB-SQL>>create table s as select * from dba_objects;
Table created.
sys@NEWDB-SQL>>select username from dba_users;
USERNAME
------------------------------
SYSTEM
SYS
OLAPSYS
SI_INFORMTN_SCHEMA
MGMT_VIEW
ORDPLUGINS
WKPROXY
XDB
SYSMAN
HR
OE
DIP
OUTLN
SH
ANONYMOUS
CTXSYS
IX
MDDATA
WK_TEST
PM
WKSYS
BI
WMSYS
SCOTT
DBSNMP
DMSYS
EXFSYS
ORDSYS
MDSYS
29 rows selected.
sys@NEWDB-SQL>>grant all on s to scott, ANONYMOUS,CTXSYS,IX,MDDATA,PM,DBSNMP,DMSYS;
Grant succeeded.
Hope this helps.
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
