Home » RDBMS Server » Security » profile of user...
profile of user... [message #117128] Mon, 25 April 2005 05:55 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

can any one tell me how to see what is present in the profile of user? ... yea i know when user is created he/she is given default profile .. i want to see what is there in default profile ... is there is any table or query to see it ...

from :- sunil
Re: profile of user... [message #117404 is a reply to message #117128] Wed, 27 April 2005 01:24 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member

Query these two views:

DBA_USERS & DBA_PROFILES.

..Girish
Re: profile of user... [message #117442 is a reply to message #117404] Wed, 27 April 2005 06:35 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

check it out please...what i have doen its not lengthy but simple query with result so please check it out ....

I can know which user have which profile .....but what is there in default profile ?

SQL> desc dba_users;
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)

SQL> desc dba_profiles
Name Null? Type
----------------------------------------- -------- ----------------------------
PROFILE NOT NULL VARCHAR2(30)
RESOURCE_NAME NOT NULL VARCHAR2(32)
RESOURCE_TYPE VARCHAR2(Cool
LIMIT VARCHAR2(40)



SQL> select RESOURCE_NAME, LIMIT from dba_profiles where profile = 'default';

no rows selected

----yea i can see the limit for resource_name for other profile ------u can see below query.

SQL> select RESOURCE_NAME, LIMIT from dba_profiles where profile = 'MONITORING_PROFILE';

RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT DEFAULT
SESSIONS_PER_USER DEFAULT
CPU_PER_SESSION DEFAULT
CPU_PER_CALL DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
IDLE_TIME DEFAULT
CONNECT_TIME DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME DEFAULT

RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_VERIFY_FUNCTION DEFAULT
PASSWORD_LOCK_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT

16 rows selected.


Can u tell me how i can set the LIMIT for RESOURCE_NAME FAILED_LOGIN_ATTEMPTS in default profile ...is it possible to so so ?

Can i set the LIMIT for RESOURCE_NAME FAILED_LOGIN_ATTEMPTS for profile other than DEFAULT profile..?

thank you

From:- sunilkumar



Re: profile of user... [message #117445 is a reply to message #117442] Wed, 27 April 2005 06:51 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Can u tell me how i can set the LIMIT for RESOURCE_NAME FAILED_LOGIN_ATTEMPTS in default profile ...is it possible to so so ?
Use the command
ALTER PROFILE profile_name LIMIT limit(s) range
where range = UNLIMITED | DEFAULT | integer | expression.
for changing any resource limit.

In ur case use "default" as the profile name.

Can i set the LIMIT for RESOURCE_NAME FAILED_LOGIN_ATTEMPTS for profile other than DEFAULT profile..?

Yes you can, but first u need to create a new profile
using "create profile" command.
Re: profile of user... [message #117446 is a reply to message #117445] Wed, 27 April 2005 07:03 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

thank you for your reply

but can u tell me why i got no row select when i executed this query as below

SQL> select RESOURCE_NAME, LIMIT from dba_profiles where profile = 'default';

no rows selected

Once again thank you girish

from :- sunil


Re: profile of user... [message #117455 is a reply to message #117446] Wed, 27 April 2005 07:31 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Use DEFAULT instead of default there in the query.
Previous Topic: urgent... password problem for oracle 10g on linux
Next Topic: REVOKE doesnot work
Goto Forum:
  


Current Time: Fri Aug 14 21:51:35 CDT 2020