Technical Notes
We're all on the same page!
Showing posts with label
profile
.
Show all posts
Showing posts with label
profile
.
Show all posts
Friday, 6 October 2017
ORA-28000 solution
›
Error ORA-28000: the account is locked Solution Find the assigned profile for related user SQL> select profile from DBA_USERS where ...
Tuesday, 1 August 2017
ORA-28002 solution
›
Error ORA-28002: the password will expire within [A] days Solution Disable password expiration SQL> select profile from DBA_USERS wh...
Wednesday, 11 January 2017
How to define timeout setting for auto logout users in linux system?
›
Configure it # vi /etc/profile add following parameter at the end of the profile file: # this parameter runs as seconds and affects all...
Wednesday, 15 October 2014
How to see all profiles and assigned limits?
›
Please execute the commands as "sys"; SQL> SELECT * FROM DBA_PROFILES ORDER BY PROFILE;
Tuesday, 14 October 2014
How to alter a profile in Oracle?
›
Please login to database server with ssh as oracle user and run that commands. sqlplus / as sysdba SQL> ALTER PROFILE engineer LIMIT...
How to define new profile or change old profile in Oracle?
›
Please login to database server with ssh as oracle user and run that commands. sqlplus / as sysdba SQL> CREATE PROFILE engineer LIMI...
›
Home
View web version