Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 assigned to the profile The SQL_ 201 user has been assigned the DEFAULT profile Every user is assigned the DEFAULT profile unless another named profile is explicitly assigned to the user during account creation or through an ALTER USER statement Currently the SQL_ 201 user can have no more than 10 failed login attempts before its user account is locked and it must be unlocked by a privileged user such as a database administrator Additionally the SQL_ 201 user is currently allowed to be connected to the database but not actively executing any statements for an unlimited amount of time These two limit settings are outlined in bold in the final result set for Listing 7 Code Listing 7 Discover the name of and resource limits for the profile assigned to the SQL_ 201 user SQL connect as sysdba Connected SQL alter session set container bynd ORACLE MAGAZINE JANUARY FEBRUARY 2018 130 Session altered SQL select profile 2 from dba_ users 3 where username SQL_ 201 PROFILE DEFAULT
You must have JavaScript enabled to view digital editions.