Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 prevent deleting in a table

Author  Topic 

ashraf_al_ani
Starting Member

2 Posts

Posted - 2012-12-01 : 15:42:23
Dear all
i am using sql server 2000 personal edition in windows 7
i am using access project (front end access) back end (sql server2000)
please is there a way to preven a user from delete any record in a table calles item?
best regards

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-01 : 19:22:08
[code]Deny delete on <tablename> to <username>[/code]
Go to Top of Page

ashraf_al_ani
Starting Member

2 Posts

Posted - 2012-12-02 : 14:27:35
thanks for responding
but please can you give me the details how can i deny delete to user name

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-02 : 19:41:25
Run above statement and replace tablename and username with original.
Go to Top of Page
   

- Advertisement -