Re: SQL Server 7 Permissions!

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 18:43:09 +0100

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). 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<b@man.com> wrote in message news:eXcNHVoHFHA.3936@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I have SQL Server 7 (SP6) installed on an NT4 (SP6a) and I have a
> problem with permissions - I set permissions on tables for a user (that
> is an NT User itself) - both using the enterprise manager and using SQL.
>
> Problem is that it doesn't matter - I can still perform
> INSERT/UPDATE/DELETE (...SELECT) on the table.
>
> What can be the problem?
>
> Thanks in advance,
> S. Neumann

Relevant Pages

  • Re: SQL Server 7 Permissions!
    ... Or member of the Windows Administrators group? ... Tibor Karaszi, SQL Server MVP ... > problem with permissions - I set permissions on tables for a user (that ...
    (microsoft.public.sqlserver.security)
  • Re: Is this an error?
    ... as XPcomputer\Chris which is a member of the ... Adminstrators Group. ... username to connect ...
    (microsoft.public.windowsxp.security_admin)
  • Re: SA password recovery
    ... >You can connect using Query Analyzer as a sysadmin role ... >trusted connection by a member of the local admin group) ... >SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: sp_change_users_login use after restore
    ... The user was a member of the sysadmin role, once I took the role out, ... In that case the login will will be 'dbo' in the ... > SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Is there a way to give public access to directory?
    ... Let me qualify that...I know how to set permissions bits. ... here is a directory in which any user who is a member of the group ... 'public' can create files that *anyone else* in the public group can modify ...
    (comp.os.linux.security)
Quantcast