Re: SQL Server 7 Permissions!

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 10:36:03 -0800

Can you verify what roles you are in and what your login name is? 

-- 
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
<b@man.com> wrote in message news:OgbxawoHFHA.2740@TK2MSFTNGP12.phx.gbl...
> Hi!
>
> The user is the user I'm using (checked) and is not sysadmin. However,
> he is a member of Windows Administrators. Is it really an issue? Can't
> I deny access from a win. admin.?
>
> Tibor Karaszi wrote:
>
>> Perhaps the user is sysadmin? Or member of the Windows Administrators
>> group? Also, check that the user is really logged in as who you think
>> (SELECT SYSTEM_USER).
>

Relevant Pages

  • Re: SQL Server 7 Permissions!
    ... SQL Server MVP ... > The user is the user I'm using and is not sysadmin. ... Or member of the Windows Administrators ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server 7 Permissions!
    ... The user is the user I'm using and is not sysadmin. ... he is a member of Windows Administrators. ... Tibor Karaszi wrote: ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 7 Permissions!
    ... The user is the user I'm using and is not sysadmin. ... he is a member of Windows Administrators. ... Tibor Karaszi wrote: ...
    (microsoft.public.sqlserver.programming)
  • Re: securityadmin server role - change password
    ... password (e.g. member of SysAdmin or SecurityAdmin fixed server role) ... SysAdmin never have to enter the old password (i.e. the field in the ... editable for members of the SecurityAdmin role. ... The only exception to this rule is when a member ...
    (microsoft.public.sqlserver.setup)
  • Re: securityadmin server role - change password
    ... In Enterprise Manager (I assume that passwords are changed via ... password (e.g. member of SysAdmin or SecurityAdmin fixed server role) ... SysAdmin never have to enter the old password (i.e. the field in the ... The only exception to this rule is when a member ...
    (microsoft.public.sqlserver.setup)