Re: Testing Table Existence - DB name as variable ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: rob (rwc1960_at_bellsouth.net)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 09:47:17 -0400

David,

I have been thinking alot about your point of view... is there any other way
to provide "row level" permissions ? Other than a client tool parameter,
or separate sp's... I figured that by setting up one database per
saleperson, 2 mistakes must occur for a salesperson to see another
salespersons data 1) the wrong connection parameters would have to be used
when setting up the MSAccess client tool, and 2) they would have to
incorrectly assign permissions to the wrong database.

Thanks

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:7q-dnRoLJ5JftX3dRVn-ug@giganews.com...
> Then allow them to view the database only through SPs that restrict them
to
> just the data they own. Segmenting databases in the way you have is
> unnecessary and it just creates a management headache, makes development
> needlessly complex (your question in this thread for example) and makes it
> cumbersome to write Decision Support queries (find the top selling
> salesperson for example).
>
> --
> David Portas
> SQL Server MVP
> --
>
>

Relevant Pages

  • Re: Table Groups?
    ... > I went back through BOL and I think I see the approach you suggest. ... I believe David was simply suggesting that you use a standard database role ... Add a Windows Group to the database and assign permissions to that group ...
    (microsoft.public.sqlserver.programming)
  • Re: Table Groups?
    ... permissions working. ... >> I believe David was simply suggesting that you use a standard database ... > or store the encrypted password in the registry of each client. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Permissions & Compacting
    ... David, thanks for the tip. ... I guess I'll just kill the compact on ... permissions so that the warehouse user can read/write. ... works great until I log in as admin and open the access database. ...
    (comp.databases.ms-access)
  • Re: How to give execute permissions to all stored procedures in the database?
    ... database?(looking to give>permissions to all at a time) ... to output a script. ... David ...
    (microsoft.public.sqlserver.security)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)