Admin access to Oracle 9i

zia.sepsis · 2008-12-22T19:14:41+00:00

i have installed oracle 9i in my pc. i want to know how to login as a administrator and how to manage passwords. As i have started learning it, i need the administrative access for the execution of special type queries.please help me.

Admin access to Oracle 9i

zia.sepsis

Member

Updated: Oct 21, 2024

Views: 1.0K

i have installed oracle 9i in my pc. i want to know how to login as a administrator and how to manage passwords. As i have started learning it, i need the administrative access for the execution of special type queries.please help me.

0

Replies

Howdy guest!

Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.

Replies

zia.sepsis

Member • Dec 24, 2008

can any one solve my problem please... its something urgent.

Are you sure? This action cannot be undone.
Cancel
safwan

Member • Dec 24, 2008

ahhh if u don mind im not expert but try this out.
username: scott
passwerd: tiger
"this are defualt username/paswerd"
salam

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Dec 24, 2008

but that's not a admin user

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Dec 24, 2008

thanks ...

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Dec 28, 2008

I have got the solution for it....
it may help you people, i guess.
the default admin accounts are
sys and system... the password for sys user is change_on_install but it has to loged on through cmd. its better to login using system user id ... the password for the above is manager.

Are you sure? This action cannot be undone.
Cancel
safwan

Member • Dec 28, 2008

salam,
thanks you this is what the moto and spirit of ceans to help and guid each other.
i was goin to post this one but sorry i was late .
😁😁

Are you sure? This action cannot be undone.
Cancel
nileshchakkar

Member • Dec 29, 2008

dude one more option
ummmm
yah
change the privilage i didnt remember exacly but with help of which we can switch from one to other i mean to say it can work as many user n many accounts

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Dec 29, 2008

nileshchakkar
dude one more option
ummmm
yah
change the privilage i didnt remember exacly but with help of which we can switch from one to other i mean to say it can work as many user n many accounts
i cant get you bro

Are you sure? This action cannot be undone.
Cancel
nileshchakkar

Member • Dec 29, 2008

actually there are commands in sql like grant and revoke.

GRANT:-

The SQL command grant allows to assign #-Link-Snipped-# and #-Link-Snipped-# to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;

grant #-Link-Snipped-# to username;
grant #-Link-Snipped-#, system_privileges_2, ..,system_privileges_n to username;
grant #-Link-Snipped-# to username #-Link-Snipped-#;

grant #-Link-Snipped-# to username;
grant #-Link-Snipped-# to username with grant option;
grant #-Link-Snipped-# to username with #-Link-Snipped-#;

The SQL command grant allows to assign #-Link-Snipped-# and #-Link-Snipped-# to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;

grant ... ANY ...

If a privilege is granted on ANY object (grant create any table to some_one), the user (or role) is given this privilege in all #-Link-Snipped-#, even in schema SYS. In order to prevent this, the initialization parameter #-Link-Snipped-# must be set to false.
with admin option

If with admin option is specified, the grantee can grant the granted privilege to someone else.
with hierarchy option

This clause only makes sense with the select privilege.
Showing granted privileges for a user

#-Link-Snipped-# allows to recursively list users, their roles and privileges.
Links

#-Link-Snipped-# (that can be granted).

REVOKE:-

It is exactly opposite to the grant.
Removes a previously granted or denied permission.

and for more detail just refer
<a href="https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm" target="_blank" rel="nofollow noopener noreferrer">SQL GRANT, REVOKE, Privileges and Roles</a>

<a href="https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm" target="_blank" rel="nofollow noopener noreferrer">SQL GRANT, REVOKE, Privileges and Roles</a>

Are you sure? This action cannot be undone.
Cancel
zia.sepsis

Member • Dec 29, 2008

nileshchakkar
actually there are commands in sql like grant and revoke.

GRANT:-

The SQL command grant allows to assign #-Link-Snipped-# and #-Link-Snipped-# to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;

grant #-Link-Snipped-# to username;
grant #-Link-Snipped-#, system_privileges_2, ..,system_privileges_n to username;
grant #-Link-Snipped-# to username #-Link-Snipped-#;

grant #-Link-Snipped-# to username;
grant #-Link-Snipped-# to username with grant option;
grant #-Link-Snipped-# to username with #-Link-Snipped-#;

The SQL command grant allows to assign #-Link-Snipped-# and #-Link-Snipped-# to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;

grant ... ANY ...

If a privilege is granted on ANY object (grant create any table to some_one), the user (or role) is given this privilege in all #-Link-Snipped-#, even in schema SYS. In order to prevent this, the initialization parameter #-Link-Snipped-# must be set to false.
with admin option

If with admin option is specified, the grantee can grant the granted privilege to someone else.
with hierarchy option

This clause only makes sense with the select privilege.
Showing granted privileges for a user

#-Link-Snipped-# allows to recursively list users, their roles and privileges.
Links

#-Link-Snipped-# (that can be granted).

REVOKE:-

It is exactly opposite to the grant.
Removes a previously granted or denied permission.

and for more detail just refer
<a href="https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm" target="_blank" rel="nofollow noopener noreferrer">SQL GRANT, REVOKE, Privileges and Roles</a>

<a href="https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm" target="_blank" rel="nofollow noopener noreferrer">SQL GRANT, REVOKE, Privileges and Roles</a>
Thanks mate

Are you sure? This action cannot be undone.
Cancel