Permissions

Question:

---

I created a new table in my SQL Server database but in DWMX I cannot get the tables to appear, why ?

Answer:

---

You forgot to set your table permissions for the SQL Server user that your webserver is using, the solution is simple:

First we expand the database in question and click on Users. All users show up in the browser part of the Enterprise manager and we right-click the desired user (in my case galen012) and we want to edit it's properties.

This looks fine to me since I login as DBO to add stuff, but yours could differ slightly, yours could read db_owner checked as well ! But we are all done here, so we click on permissions in the top right and a nasty looking window pops up.

This looks more confusing then it is, here are all your database objects and you give permissions here, so remember this place and how you got here.

With the select list we can select another user login for this database to change permissions for, great !
With the radio group below that we can show ALL objects or only the objects this user currently has permissions for, if we were to swap that radio group around now then everything would disappear since we have no permissions yet.

I am going to give every table, SELECT, INSERT, UPDATE and DELETE permissions, except the SYS tables that SQL Server creates, because my administration is all webbased. To do that we check every option desired in EVERY table (I know, I did not design this) and that is all, if you click twice you get DENY permission with a red X instead of the green check sign, doing exactly the opposite, it locks you out of that object.

And now our permissions are all set, you can also set permissions on a column basis which works basically the same, it can come in handy to hide a Salary column, just DENY SELECT rights to the user that is not supposed to see that, by checking it RED and it now is impossible to SELECT from that column for that user.