Solved

Super User when installing  Oracle 8i

Posted on 2001-09-08
6
688 Views
Last Modified: 2012-06-21
Hello All

I have just installed Oracle 8i on a Windows NT platform.  I can access the sample database using the user name 'SCOTT' and password 'TIGER'

However I cannot access all the sample tables, as all tables are not owned by SCOTT, some are by SYS or by DEMO etc.

Is anyone aware if there is a default super user who has access to all database objects, if so what is user name and password.  Or can I re-set the passwords for other users such as DEMO.

I look forward to a reply.

Thanks in a advance.


Regards


Asif Mughal
0
Comment
Question by:AsifMughal
6 Comments
 
LVL 2

Expert Comment

by:noriegaa
ID: 6467279
You can connect as internal from server manager.  From your NT console, type:

set oracle_sid = orcl  
(if you use the default database, otherwise the SID you used)

SVRMGR> connect internal
password: oracle

SVRMGR>alter user system identified by my_new_password1;
statement processed.
SVRMGR>alter user sys identified by my_new_password2;
statement processed.
SVRMGR>alter user demo identified by my_new_password3;
statement processed.
SVRMGR>grant select_catalog_role to scott,demo;

(my_new_password1,2,3 represent you new selected password).

If you need to create new tables, there are various demo scripts as bdemobld.sql in the

%ORACLE_HOME%\RDBMS\admin , if you are using the default then it should be, it should look like:

d:\Oracle\Ora81\RDBMS\admin


Most demo scripts have a name like demobld.sql or so.
I wish this information is useful to you.
0
 
LVL 2

Expert Comment

by:noriegaa
ID: 6467280
You can connect as internal from server manager.  From your NT console, type:

set oracle_sid = orcl  
(if you use the default database, otherwise the SID you used)

SVRMGR> connect internal
password: oracle

SVRMGR>alter user system identified by my_new_password1;
statement processed.
SVRMGR>alter user sys identified by my_new_password2;
statement processed.
SVRMGR>alter user demo identified by my_new_password3;
statement processed.
SVRMGR>grant select_catalog_role to scott,demo;

(my_new_password1,2,3 represent you new selected password).

If you need to create new tables, there are various demo scripts as bdemobld.sql in the

%ORACLE_HOME%\RDBMS\admin , if you are using the default then it should be, it should look like:

d:\Oracle\Ora81\RDBMS\admin


Most demo scripts have a name like demobld.sql or so.
I wish this information is useful to you.
0
 
LVL 2

Expert Comment

by:mccallw
ID: 6467295
The two default users that you are interested in are:

userid/password

system/manager
sys/change_on_install

If you haven't changed these passwords you will be able to log in as system or sys using these passwords.

Warren
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 2

Expert Comment

by:RMZ
ID: 6468350
HI
note that
any user can change his password but if user have have dba privlge so he can change any  password
alter user username identified by password;
note that the user which have a dba privlger such as system/manager
sys/change_on_install
also internal all of them are supper users
---rmz----
0
 

Accepted Solution

by:
BilltheMan earned 50 total points
ID: 6469208
Super User

sysman/oem_temp
0
 
LVL 2

Expert Comment

by:noriegaa
ID: 6480581
sysman refers to an OEM super user account not to an Oracle8i user id.  It is a user id utilized to log onto the repository via the OEM console. You could use my recommendation above. However, if you happened to use OEM, you could easily use Security Manager to make any necessary changes in a user-friendly GUI way.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle 12c patching 1 61
case statement in where clause 5 41
How to free up undo space? 3 29
Oracle 10g standard edition server with 4 processors 3 33
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now