basic security questions - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

basic security questions

Author

Topic

viniciov
Starting Member

2 Posts

Posted - 2010-01-07 : 13:27:07

Hi. I'm somehow new to SQL Server. I have some basic questions.

1. If I drop a database user (not a login), is there any default audit or log for this event?

2. Is there any way to lock the user (ie. ALTER USER XXX ACCOUNT LOCK) like in Oracle?

Regards

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-07 : 14:08:03

1. No. But do have a look at this: http://blogs.technet.com/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx

2. Yes. You can disable the login

viniciov
Starting Member

2 Posts

Posted - 2010-01-07 : 14:16:32

quote:
Originally posted by russell

1. No. But do have a look at this: http://blogs.technet.com/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx

2. Yes. You can disable the login

What is the command for performing the second action? Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 14:22:54

ALTER LOGIN <login name> ENABLE | DISABLE

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources