Re: Authentication and impersonation

From: "Tasos Vogiatzoglou" <tvoglou@xxxxxxxxx>
Date: 21 Oct 2005 00:28:53 -0700

Most probably user_A is member of a group that has permissions on the
SQL Server. Check the groups that have access to SQL server including
the local machine security groups.

user_A may be a member of the local administrators group.

.

References:
- Authentication and impersonation
  - From: Eric

Prev by Date: Re: Building Multilingual Portal
Next by Date: Re: Techniques to auto-login using a persistent cookie.
Previous by thread: Authentication and impersonation
Next by thread: Re: Building Multilingual Portal
Index(es):
- Date
- Thread

Relevant Pages

Re: Alter Many Stored Procedures
... permissions to create/drop/alter other objects as well. ... a member of the db_ddladmin fixed database role ... SQL Server MVP ...
(microsoft.public.sqlserver.security)
Re: cannot acees two databases as owner
... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
(microsoft.public.sqlserver.setup)
Re: SQL Login
... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
(microsoft.public.sqlserver.security)
RE: exec sp_help_job user account rights
... Execute permissions default to the public role in the msdb database. ... who can execute this procedure and is a member of the sysadmin fixed role can ... the SQL Server service is running. ... impersonation and sp_help_job is always executed under the security context ...
(microsoft.public.sqlserver.security)
Re: System Administrator Implied Permissions
... member of the dbo group and you are automatically given ... Now, given this, why does SQL Server ... Much Thanks Dan. ...
(microsoft.public.sqlserver.security)