Deny access to tables

Hi,
I was hoping someone could help me with a problem I have
in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
Server in a few years, so I'm quite rusty.
How do you allow a user access to a database but restrict
what tables they can see/edit. The problem I'm
experiencing is the Public role, I can't seem to delete
it and I don't want to change it's permissions as all the
other users need access to the tables it allows..
Any help - I'm probably missing something so basic and
will kick myself.
Many thanks in advance for any help received.
MichelleHi;
Have a look into DENY statement in Books online
Sample statement to deny all revilages on emp_master table from user : test
DENY all on emp_master to test
Thanks
Hari
MCDBA
"Michelle T" <anonymous@.discussions.microsoft.com> wrote in message
news:192e801c44c78$5252a170$a001280a@.phx
.gbl...
> Hi,
> I was hoping someone could help me with a problem I have
> in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
> Server in a few years, so I'm quite rusty.
> How do you allow a user access to a database but restrict
> what tables they can see/edit. The problem I'm
> experiencing is the Public role, I can't seem to delete
> it and I don't want to change it's permissions as all the
> other users need access to the tables it allows..
> Any help - I'm probably missing something so basic and
> will kick myself.
> Many thanks in advance for any help received.
> Michelle
>|||Hari,
Thanks for that, I thought that a script might be what
was required.
Thanks for all your help.
Michelle
>--Original Message--
>Hi;
>Have a look into DENY statement in Books online
>Sample statement to deny all revilages on emp_master
table from user : test
>DENY all on emp_master to test
>Thanks
>Hari
>MCDBA
>"Michelle T" <anonymous@.discussions.microsoft.com> wrote
in message
> news:192e801c44c78$5252a170$a001280a@.phx
.gbl...
have[vbcol=seagreen]
restrict[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>