Home All Groups Group Topic Archive Search About

Database Table special permissions

Author
29 Dec 2005 12:41 PM
Maria Bravo
Hi, I would like to know if is there any way to create a database table which
I don´t want to allow new entries, just modifying existing records. Something
like the private SQL tables. I don´t want any user with privileges to insert
manually new records, I would like this table to be a Catalog.
TIA

Author
29 Dec 2005 12:45 PM
Uri Dimant
Hi

DENY INSERT
ON table
TO username




Show quote
"Maria Bravo" <Maria Br***@discussions.microsoft.com> wrote in message
news:A68D1607-309A-44BC-89A7-6F09B6997388@microsoft.com...
> Hi, I would like to know if is there any way to create a database table
> which
> I don´t want to allow new entries, just modifying existing records.
> Something
> like the private SQL tables. I don´t want any user with privileges to
> insert
> manually new records, I would like this table to be a Catalog.
> TIA

AddThis Social Bookmark Button