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 |
|
sgondesi
Posting Yak Master
200 Posts |
 Posted - 2013-11-01 : 13:29:41
|
| Will the password of a user account expires? If yes,when?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-01 : 13:39:25
|
| depends on setting you gave while you created it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-01 : 15:40:05
|
| Password expires (or not expires) for a LOGIN (rather than a user). In SQL parlance, login is the entity that logs into the server, and user is the entity that has rights to a database.In any case, right-click on the login name under security -> login under the server name in SSMS object explorer and select properties. That will show you whether the password expiration policy is set or not. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-01 : 15:40:45
|
quote:
Originally posted by visakh16
depends on setting you gave while you created it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Or the current setting if someone updated the setting after it was created. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-02 : 23:55:42
|
quote:
Originally posted by visakh16
depends on setting you gave while you created it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Thanq sir.I will get back to you after learning things related to this concept.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-03 : 00:09:54
|
quote:
Originally posted by James K
Password expires (or not expires) for a LOGIN (rather than a user). In SQL parlance, login is the entity that logs into the server, and user is the entity that has rights to a database.In any case, right-click on the login name under security -> login under the server name in SSMS object explorer and select properties. That will show you whether the password expiration policy is set or not.
What i mean was..Say that i have a user whom i need to give access for my database for some particular period only. After that period, i want to take away the access from that user.I can delete the user account for accomplishing this. But i dont want to do that because, i may again wanted to give the database access to him in future.So i want a password that was given to a user to be expired in some time period. And then if i feel that the user's access to database is required, then i wanted to give him again.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-03 : 03:09:37
|
quote:
Originally posted by sgondesi
quote:
Originally posted by James K
Password expires (or not expires) for a LOGIN (rather than a user). In SQL parlance, login is the entity that logs into the server, and user is the entity that has rights to a database.In any case, right-click on the login name under security -> login under the server name in SSMS object explorer and select properties. That will show you whether the password expiration policy is set or not.
What i mean was..Say that i have a user whom i need to give access for my database for some particular period only. After that period, i want to take away the access from that user.I can delete the user account for accomplishing this. But i dont want to do that because, i may again wanted to give the database access to him in future.So i want a password that was given to a user to be expired in some time period. And then if i feel that the user's access to database is required, then i wanted to give him again.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
Thats not the way to do it.If you dont want his login to be active after a period easiest way is to disable the account from SSMS. That just takes a single click action from you end. You can always come back and activate it anytime you want.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-04 : 05:24:08
|
quote:
Originally posted by visakh16
quote:
Originally posted by sgondesi
quote:
Originally posted by James K
Password expires (or not expires) for a LOGIN (rather than a user). In SQL parlance, login is the entity that logs into the server, and user is the entity that has rights to a database.In any case, right-click on the login name under security -> login under the server name in SSMS object explorer and select properties. That will show you whether the password expiration policy is set or not.
What i mean was..Say that i have a user whom i need to give access for my database for some particular period only. After that period, i want to take away the access from that user.I can delete the user account for accomplishing this. But i dont want to do that because, i may again wanted to give the database access to him in future.So i want a password that was given to a user to be expired in some time period. And then if i feel that the user's access to database is required, then i wanted to give him again.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
Thats not the way to do it.If you dont want his login to be active after a period easiest way is to disable the account from SSMS. That just takes a single click action from you end. You can always come back and activate it anytime you want.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
sir,Actually i heard that we can create only one login for a database.is it true?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-04 : 06:33:18
|
quote:
Originally posted by sgondesi
quote:
Originally posted by visakh16
quote:
Originally posted by sgondesi
quote:
Originally posted by James K
Password expires (or not expires) for a LOGIN (rather than a user). In SQL parlance, login is the entity that logs into the server, and user is the entity that has rights to a database.In any case, right-click on the login name under security -> login under the server name in SSMS object explorer and select properties. That will show you whether the password expiration policy is set or not.
What i mean was..Say that i have a user whom i need to give access for my database for some particular period only. After that period, i want to take away the access from that user.I can delete the user account for accomplishing this. But i dont want to do that because, i may again wanted to give the database access to him in future.So i want a password that was given to a user to be expired in some time period. And then if i feel that the user's access to database is required, then i wanted to give him again.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
Thats not the way to do it.If you dont want his login to be active after a period easiest way is to disable the account from SSMS. That just takes a single click action from you end. You can always come back and activate it anytime you want.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
sir,Actually i heard that we can create only one login for a database.is it true?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
What do you mean by that?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-04 : 06:46:05
|
| I am asking if it is true or not.if it true, then all the users who are given access to that database(by mapping them to the login) will loose their access right?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-04 : 06:49:18
|
| Actually, somebody who is the member of this forum has told me that we can only create one login per database. But i never read it.So i am doubtful in that.Thats why i asked you in that way.Please dont mind if my language seem to be like informal. This is my actual intension.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-04 : 06:50:29
|
quote:
Originally posted by sgondesi
Actually, somebody who is the member of this forum has told me that we can only create one login per database. But i never read it.So i am doubtful in that.Thats why i asked you in that way.Please dont mind if my language seem to be like informal. This is my actual intension.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
you can create as many logins as you want in database.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-04 : 06:53:55
|
quote:
Originally posted by visakh16
quote:
Originally posted by sgondesi
Actually, somebody who is the member of this forum has told me that we can only create one login per database. But i never read it.So i am doubtful in that.Thats why i asked you in that way.Please dont mind if my language seem to be like informal. This is my actual intension.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
you can create as many logins as you want in database.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Then its fine sir.I will just check that and get back to you.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-04 : 07:04:03
|
| thank you sir.my issue got confirmed. thanks a lot.Really Sorry if i hurt you with my texting. I dint do it intentionally.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
|
|
|
|
Password Expiration