January 19, 2017 at 12:02 pm
hi
In the database, data of some tables are very important and I do not want users sees them(no data & no table design)
is this possible?
January 19, 2017 at 12:09 pm
If you haven't granted them access to the table, they can't gain access. Unless you've given them a role of db_datareader, for example, on your database (which enables them to access all data on the database unless specifically DENIED), or the a server role of sysadmin then they won't be able to access the data.
SQL operates on permissive credentials. If you haven't been given permission to do something, you can't. Also, however, if you give someone access (for example via a role), and then expressively deny it, then they also can't do it.
If everyone has sysadmin though, then you need a serious review of your security.
Does this help?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply