SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Password Expiration
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/01/2013 :  13:29:41  Show Profile  Reply with Quote
Will the password of a user account expires? If yes,when?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/01/2013 :  13:39:25  Show Profile  Reply with Quote
depends on setting you gave while you created it.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3712 Posts

Posted - 11/01/2013 :  15:40:05  Show Profile  Reply with Quote
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.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3712 Posts

Posted - 11/01/2013 :  15:40:45  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

depends on setting you gave while you created it.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs


Or the current setting if someone updated the setting after it was created.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/02/2013 :  23:55:42  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

depends on setting you gave while you created it.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/03/2013 :  00:09:54  Show Profile  Reply with Quote
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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/03/2013 :  03:09:37  Show Profile  Reply with Quote
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 Regards
Srikar 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/04/2013 :  05:24:08  Show Profile  Reply with Quote
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 Regards
Srikar 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 MVP
http://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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/04/2013 :  06:33:18  Show Profile  Reply with Quote
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 Regards
Srikar 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 MVP
http://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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.


What do you mean by that?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/04/2013 :  06:46:05  Show Profile  Reply with Quote
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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/04/2013 :  06:49:18  Show Profile  Reply with Quote
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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/04/2013 :  06:50:29  Show Profile  Reply with Quote
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 Regards
Srikar 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/04/2013 :  06:53:55  Show Profile  Reply with Quote
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 Regards
Srikar 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




Then its fine sir.
I will just check that and get back to you.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/04/2013 :  07:04:03  Show Profile  Reply with Quote
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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000