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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

JohnM avatar image JohnM commented ·
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 ·
artistlover avatar image artistlover commented ·
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 ·
JohnM avatar image JohnM commented ·
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

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.