Public Group Security Issue

From: Robert Keck (robertk@fprodsa.com)
Date: 11/09/02 

From: "Robert Keck" <robertk@fprodsa.com>
Date: Fri, 08 Nov 2002 23:44:50 GMT

What am I missing???

I'm new to SQL server and am in the process of doing some compatibility
testing

I've a table on a SQL2000 server that is joined to an AD domain (using
Windows Only security)

I've added domain users and domain groups to the SQL database and assigned
appopriate permissions to the table.

However, the only security changes that matter are table permission changes
to the Public group i.e. if I deny ALL permissions to the Public group (at
the table level), and give ANY/ALL permissions to one of the other groups
and/or users, an appropriate user (on another machine), via an MS Access adp
file, can not access or see the table. Basically, the SQL server seems to
only be concerned with permissions of the Public group and totally
disregards everything else.

Thanks in advance

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... functionality using our WinForm app and read-only functionality using ... SQL Server permissions are not application-aware. ... App1 contains CRUD functionality using stored procs (EXEC perms on ...
    (microsoft.public.sqlserver.security)
Quantcast