Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User defined roles problem

Status
Not open for further replies.
slames

slames

Technical User
Nov 5, 2002
211
GB
I am trying to implement user defined roles in my SQL Server 2000 database and am experiencing difficulties denying delete permission from users.
I have set up a role with myself as the only member and have set it to allow select and insert permissions and deny delete permissions on a single table in the database. I have also denied public the ability to delete from theis table. I do not belong to any other groups but I am still able to delete records from this table. Can anyone help me on this.
#
Thanks

Steph
 
Sort by date Sort by votes
Might be worth asking this in the MS SQL Server Setup and Administration Forum
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
400
Andrzejek
Andrzejek
baran121
  • Locked
  • Question
sql user default language problem
Replies
7
Views
414
gmmastros
gmmastros
SamBones
  • Locked
  • Question
Problem with ON UPDATE CURRENT_TIMESTAMP
Replies
0
Views
357
SamBones
SamBones
Auguy
  • Locked
  • Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1
Replies
2
Views
267
Auguy
Auguy
grnzbra
  • Locked
  • Question
Unmatched Query Problem 1
Replies
2
Views
285
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top