-
Drop the default oracle users
Hi,
I want to drop the default oracle users except sys and system.Is there any .sql file in the rdbms/admin folder.
DBSNMP 17
AURORA$JIS$UTILITY$ 26
AURORA$ORB$UNAUTHENTICATED 28
SCOTT 66
OEMUSER 76
SCOTT1 79
ADMIN 74
OSE$HTTP$ADMIN 27
OUTLN 11
WKSYS 34
QS_CBADM 62
QS_OS 61
QS_ES 60
SH 56
PM 55
OE 54
HR 53
QS_WS 59
QS 58
QS_ADM 57
QS_CS 64
QS_CB 63
RMAN 65
OLAPDBA 40
CTXSYS 32
OLAPSVR 39
OLAPSYS 37
MDSYS 31
ORDPLUGINS 30
ORDSYS 29
Thanks
-
select 'drop user '||username||' cascade;' from dba_users where username not in ('SYS','SYSTEM');
or
select 'drop user '||username||' cascade;' from dba_users where username in ('give all the usernames');
HTH
Amar
Amar
"There is a difference between knowing the path and walking the path."
-
See these docs on Metalink.
160861.1
207560.1
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
hi,
Where can i find the oracle docs (160861.1 ,207560.1)in the metalink...I can see links like Database ,installation,performance....
Thanks,
Ramesh
-
Hi,
Found the docs!! thanks
Thanks
Ramesh
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
|
Click Here to Expand Forum to Full Width
|