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