sql server msde: Hi,

Quick question for the experts out there:

I have MSDE installed on a remote server and I access the data via Access(ADP).

I now want someone else to access one perticular DB on the server.
I have created a new user/role and eveything no problem.
But, how do I only allow the user to view certain tables within the DB?
Is this even possible?
(The user will be accessing the data via Access(ADP))

Any help appriciated.

Thanks

hi H,
"HarryS" <harrys@gmail.com> ha scritto nel messaggio
news:b96c3804.0411260646.721c7057@posting.google.com
[quoted text, click to view]

you have to restrict user's privileges on the tables/objects you do not want
to "share"...
create a role and DENY SELECT/INSERT/UPDATE/DELETE on that objects
then add all relevant database users to that role .....

DENY SELECT, INSERT, UPDATE, DELETE
ON dbo.ObjectName
TO Role

please have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_2b95.asp
for DENY synopsis..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply