|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 12/13/2005 : 07:38:43
|
Sudripta writes "Dear Sir,
In Oracle, we can create the profile by using below mentioned syntax
CREATE PROFILE
Create a user profile
Syntax:
CREATE PROFILE profile_name LIMIT limit(s) range
KEY
limit = SESSIONS_PER_USER
CPU_PER_SESSION
CPU_PER_CALL
CONNECT_TIME
IDLE_TIME
LOGICAL_READS_PER_SESSION
LOGICAL_READS_PER_CALL
COMPOSITE_LIMIT
PRIVATE_SGA
range = UNLIMITED | DEFAULT | integer
for PRIVATE_SGA specify K or M
e.g.
CREATE PROFILE MyProfile LIMIT PRIVATE_SGA 50 K
New with Oracle 8 are password related profile limits...
Syntax:
CREATE PROFILE profile_name LIMIT pw_limit(s) range
KEY
pw_limit = PASSWORD_LIFE_TIME
PASSWORD_GRACE_TIME
PASSWORD_REUSE_TIME
PASSWORD_REUSE_MAX
FAILED_LOGIN_ATTEMPS
PASSWORD_LOCK_TIME
range = UNLIMITED | DEFAULT | expression
Syntax to customise password verification:
CREATE PROFILE profile_name LIMIT PASSWORD_VERIFY_FUNCTION {plsql_function | NULL | DEFAULT}
Definitions
CONNECT_TIME - Max. time user may stay connected
IDLE_TIME - Max. time user may stay connected & idle
PRIVATE_SGA - Session space in the shared pool - K or M (bytes)
COMPOSITE_LIMIT - A weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.
PASSWORD_LIFE_TIME - Expire password after X no of days
PASSWORD_GRACE_TIME - Lock account X days after LIFE_TIME expires.
PASSWORD_REUSE_TIME - Min. no. days before the same pw may be reused
PASSWORD_REUSE_MAX - Min. no. of number of pw changes before the current password can be reused
FAILED_LOGIN_ATTEMPS - Max no. of incorrect logins before account is locked
PASSWORD_LOCK_TIME - Max. no. of days an account will be locked
Does SQL SERVER supports Profile like oracle?
If so,Would be greate if you can give me the SQL statement for creating profile.
Thanks in advance,
Regards
Rakshit.S
VisualSoft technologies
Hyderbad." |
|
Alternative of Oracle Profiler in SQL SERVER 2000
Forum Locked
