Home » SQL & PL/SQL » SQL & PL/SQL » Granting permission to schema
Granting permission to schema [message #234865] Thu, 03 May 2007 06:26 Go to next message
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 Go to previous messageGo to next message
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 #234879 is a reply to message #234874] Thu, 03 May 2007 06:56 Go to previous messageGo to next message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

I can login as a DBA. Please let me know how to grant permission to users on more than one schema(schema of one user to another user).


Thanks,
MOna
Re: Granting permission to schema [message #234886 is a reply to message #234879] Thu, 03 May 2007 07:07 Go to previous message
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
Previous Topic: UTL_FILE
Next Topic: table type
Goto Forum:
  


Current Time: Sun Dec 11 04:17:57 CST 2016

Total time taken to generate the page: 0.04383 seconds