Tuesday, April 10, 2012

Resetting Password SYS and SYSTEM ACCOUNTS in ORACLE 11g

User Accounts/ Passwords

To Connect to Database using "/" account
> Connect / as SYSDBA

To Connect to a user account,
> Connect {UserId}
> Password: {Password}

To reset password of a user account,
> Alter User {UserId} identified by (New Password);

To create a new user
> Create User {UserId} Identified by (Password);

To Grant Revoke Permissions to Users
> Grant (Permissions) On (Object Name) to (UserId)
> Revoke (Permissions) On (Object Name) from (UserId)

Example :
Grant CONNECT, RESOURCE to dbaUser 1;
Grant Execute on usp_Abc to dbaUser1;

No comments:

Post a Comment