|
Home > Archive > MS SQL Server security > November 2005 > SQL Logins
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi All,
Is there a way or any stored procedure that will disable SQL logins(not
windows) but create as SQL server logins.
Alter Logins and SP_Deny does not work.
Thanks
Anil
| |
| Sue Hoegemeier 2005-10-28, 9:23 am |
| I'm not sure of what you are specifically asking. If you set
the authentication mode of SQL Server to allow Windows
Authentication only, then SQL logins will not work.
If you want to remove a specific SQL login, you use
sp_droplogin. sp_denylogin is used for Windows logins only.
-Sue
On Fri, 28 Oct 2005 05:13:03 -0700, "Andy"
<Andy@discussions.microsoft.com> wrote:
>Hi All,
>
>Is there a way or any stored procedure that will disable SQL logins(not
>windows) but create as SQL server logins.
>Alter Logins and SP_Deny does not work.
>
>Thanks
>Anil
| |
| Andy Davis 2005-11-29, 3:23 am |
| Hi,
then why dont you create a windows user group department wise
(marketing,packaging
,admin etc.) then in SQL Server create a ROLE based on
those of Deparment needs and assign them proper and require permissions and
then map those Windows User Group with SQL ROLE and it is done.
Regards
--
Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
"Sue Hoegemeier" wrote:
> I'm not sure of what you are specifically asking. If you set
> the authentication mode of SQL Server to allow Windows
> Authentication only, then SQL logins will not work.
> If you want to remove a specific SQL login, you use
> sp_droplogin. sp_denylogin is used for Windows logins only.
>
> -Sue
>
> On Fri, 28 Oct 2005 05:13:03 -0700, "Andy"
> <Andy@discussions.microsoft.com> wrote:
>
>
>
|
|
|
|
|