MS SQL Server security

Author

Securables

Leila

2006-11-17, 7:12 pm

Hi,
Why a SQL Server Login is securable? How do we secure it?
Thanks in advance,
Leila

Tibor Karaszi

2006-11-17, 7:12 pm

You can grant some login to for instance change password on another login. The later login is in
this context a securable.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Leila" <Leilas@hotpop.com> wrote in message news:ud3xpvnCHHA.2316@TK2MSFTNGP04.phx.gbl...
> Hi,
> Why a SQL Server Login is securable? How do we secure it?
> Thanks in advance,
> Leila
>
>
>

John Bell

2006-11-17, 7:12 pm

Hi Leila

Securables are in one of three possible scopes server, database, and schema.
They can be logins, assemblies, tables etc etc... See
http://msdn2.microsoft.com/en-us/library/ms190401.aspx for a more detailed
description. You can GRANT
http://msdn2.microsoft.com/en-us/library/ms178569.aspx ,DENY
http://msdn2.microsoft.com/en-us/library/ms188338.aspx or REVOKE
http://msdn2.microsoft.com/en-us/library/ms187728.aspx different permissions
on a securable to control how your system is secured.

HTH

John
"Leila" wrote:

> Hi,
> Why a SQL Server Login is securable? How do we secure it?
> Thanks in advance,
> Leila
>
>
>
>

Sponsored Links