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