René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Alter user in Oracle SQL | ||
Alter user <user> quotaalter user <user_name> quota unlimited on <tablespace_name>; alter user <user_name> quota 1M on <tablespace_name>;
Sets the quota for a user on a
tablespace.
Alter user <user> identified by NEW_PASSWORDAlter user <user> connect through <proxy_user>
See this link.
Alter user <user> profile
This command allows to define a profile for a user:
alter user <user_name> profile change_password_profile |