Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-12-13 : 07:38:43
|
Sudripta writes "Dear Sir,In Oracle, we can create the profile by using below mentioned syntaxCREATE PROFILECreate a user profileSyntax: CREATE PROFILE profile_name LIMIT limit(s) rangeKEY 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 | integerfor PRIVATE_SGA specify K or Me.g.CREATE PROFILE MyProfile LIMIT PRIVATE_SGA 50 KNew with Oracle 8 are password related profile limits...Syntax: CREATE PROFILE profile_name LIMIT pw_limit(s) rangeKEY pw_limit = PASSWORD_LIFE_TIME PASSWORD_GRACE_TIME PASSWORD_REUSE_TIME PASSWORD_REUSE_MAX FAILED_LOGIN_ATTEMPS PASSWORD_LOCK_TIME range = UNLIMITED | DEFAULT | expressionSyntax 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,RegardsRakshit.SVisualSoft technologiesHyderbad." |
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-12-13 : 09:44:06
|
I know SQL Server 2000 does not support things like CPU quotas, and Password expiration. SQL 2005 does have password expiration, but I am not certain it has login based CPU quotas.The short answer is no. |
|
|
|
|
|