OraFAQ Forum: Security » profile of user...

Home » RDBMS Server » Security » profile of user...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

profile of user... [message #117128]

Mon, 25 April 2005 05:55

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

Report message to a moderator

Re: profile of user... [message #117404 is a reply to message #117128]

Wed, 27 April 2005 01:24

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Query these two views:

DBA_USERS & DBA_PROFILES.

..Girish

Report message to a moderator

Re: profile of user... [message #117442 is a reply to message #117404]

Wed, 27 April 2005 06:35

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

Report message to a moderator

Re: profile of user... [message #117445 is a reply to message #117442]

Wed, 27 April 2005 06:51

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.

Report message to a moderator

Re: profile of user... [message #117446 is a reply to message #117445]

Wed, 27 April 2005 07:03

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

Report message to a moderator

Re: profile of user... [message #117455 is a reply to message #117446]

Wed, 27 April 2005 07:31

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Use DEFAULT instead of default there in the query.

Report message to a moderator

Previous Topic:	urgent... password problem for oracle 10g on linux
Next Topic:	REVOKE doesnot work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 19:24:05 CDT 2023