AsifMughal
asked on
Super User when installing Oracle 8i
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
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
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\admi n
Most demo scripts have a name like demobld.sql or so.
I wish this information is useful to you.
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\admi
Most demo scripts have a name like demobld.sql or so.
I wish this information is useful to you.
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
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
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----
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----
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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\admi
Most demo scripts have a name like demobld.sql or so.
I wish this information is useful to you.