Re: SQL 2000 securing records...

Read
http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm




"Mrpush" <Mrpush@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6A3AEC5E-759E-40E9-AA84-B2A40A671342@xxxxxxxxxxxxxxxx
Hello,

Using a SQL 2000 DB with many tables in a payroll type application.

I have IT staff that work with the tables and records, but I want to
restrict their view of IN-HOUSE payroll records. (they dont need to know
everyones salary). Is there a way to restrict access to multiple records
in
multiple tables based on some creteria is SQL?

Thanks much,

Mark


.

Relevant Pages

  • Re: Securing Microsoft SQL Enterprise Manager
    ... I would be most grateful if you could explain how to restrict access to MMC. ... at what point during SQL installation on the client should I restrict Enterprise Manager snap-in? ...
    (microsoft.public.cert.mcdba)
  • Re: Interpolation Query...
    ... I follow your interpolation math but the SQL ... variables and then my main query will do the interpolation correct? ... Why then do i get multiple records back. ... >> when I reopen the qury in the designer the brackets are back. ...
    (microsoft.public.access.queries)
  • Re: Users
    ... For Login creation SQL serevr uses the system procedure sp_addlogin, ... automatically picks MASTER database as default if the ... Login to OS using a admin user and connect to SQL server in trunsted mode ... Group" how do I change that password or restrict access through it. ...
    (microsoft.public.sqlserver.server)
  • how to transactions with Cursoradapters and sql
    ... I have created a CursorAdapter to insert and update multiple records in a ... After updating/inserting multiple records or so, i need to be able to roll ... even if i use a TRANSACTION in the SQL (by issuig BEGIN ... How can i rollback the changes after having issued a TABLEUPDATE? ...
    (microsoft.public.fox.helpwanted)
  • Re: Interpolation Query...
    ... I follow your interpolation math but the SQL ... > query is a little bit over my head and im trying to grasp what its ... > Why then do i get multiple records back. ... >> edit the SQL statement in the SQL view only. ...
    (microsoft.public.access.queries)