zia.sepsis
zia.sepsis
Branch Unspecified
29 Dec 2008

Admin access to Oracle 9i

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.
zia.sepsis

zia.sepsis

Branch Unspecified
10 years ago
can any one solve my problem please... its something urgent.
safwan

safwan

Branch Unspecified
10 years ago
ahhh if u don mind im not expert but try this out.
username: scott
passwerd: tiger
"this are defualt username/paswerd"
salam
zia.sepsis

zia.sepsis

Branch Unspecified
10 years ago
but that's not a admin user
zia.sepsis

zia.sepsis

Branch Unspecified
10 years ago
thanks ...
zia.sepsis

zia.sepsis

Branch Unspecified
10 years ago
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.
safwan

safwan

Branch Unspecified
10 years ago
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 .
😁😁
nileshchakkar

nileshchakkar

Branch Unspecified
10 years ago
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
zia.sepsis

zia.sepsis

Branch Unspecified
10 years ago
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
nileshchakkar

nileshchakkar

Branch Unspecified
10 years ago
actually there are commands in sql like grant and revoke.

GRANT:-

The SQL command grant allows to assign system privileges and object privileges to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;

grant system_privilege to username;
grant system_privilege_1, system_privileges_2, ..,system_privileges_n to username;
grant system_privilege_1 to username with admin option;

grant object_privilege to username;
grant object_privilege to username with grant option;
grant object_privilege to username with hierarchy option;

The SQL command grant allows to assign system privileges and object privileges 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 schemas, even in schema SYS. In order to prevent this, the initialization parameter o7_dictionary_accessibility 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

This script allows to recursively list users, their roles and privileges.
Links

List of system privileges (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
SQL GRANT, REVOKE, Privileges and Roles

https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm
zia.sepsis

zia.sepsis

Branch Unspecified
10 years ago
nileshchakkar
actually there are commands in sql like grant and revoke.

GRANT:-

The SQL command grant allows to assign system privileges and object privileges to users and roles.
For example, granting select and update to a table:
grant select, update on table_foo to user_bar;

grant system_privilege to username;
grant system_privilege_1, system_privileges_2, ..,system_privileges_n to username;
grant system_privilege_1 to username with admin option;

grant object_privilege to username;
grant object_privilege to username with grant option;
grant object_privilege to username with hierarchy option;

The SQL command grant allows to assign system privileges and object privileges 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 schemas, even in schema SYS. In order to prevent this, the initialization parameter o7_dictionary_accessibility 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

This script allows to recursively list users, their roles and privileges.
Links

List of system privileges (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
SQL GRANT, REVOKE, Privileges and Roles

SQL GRANT, REVOKE, Privileges and Roles
Thanks mate

Share this content on your social channels -

Only logged in users can reply.