question

artistlover avatar image
artistlover asked

sql login setting

I have groups added and for some reason when I brought them into 2012 they can write to database they do not have rights to. Thoughts on how to block them so they see data but cannot alter the data in database.
sql 2012
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1) I'd determine how the group is getting their permissions. 2) Explicitly deny the ability to write (update/delete/insert) to the database (or specific objects if needed) to the group. The DENY should take precedence over everything else.
0 Likes 0 ·
I put deny writer on that database for the groups and they could not see layers in program instead all they saw was table design.
0 Likes 0 ·
Is that good or bad? I can't tell from your comment. Are they accessing the database through an application then?
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.