June 1, 2006 at 1:21 pm
Hi All,
I got an permission error from SQL server complaining that user 'XXX' doesn't have permission to insert into table 'Table A'. In the enterprise manager, I clicked on the permissions button for table and noticed that the user 'XXX' didn't have a green check mark for any of the operations (Insert, delete, update etc).
Now user 'XXX' does have permissions to insert into 'Table B'. But, in enterprise manager I don't see the permissions reflected when I right click on the table and view permissions.
My question is : How can I determine the INSERT,UPDATE,DELETE permissions that a user has a for table using the enterprise manager?
Thanks,
Rajesh
June 1, 2006 at 4:28 pm
Perhaps user 'XXX' is a member of the db_datawriter fixed database role? If he is, you wouldn't see an object permission for the user because the permission is granted to the role.
In our shop, we make developers members of the db_datareader and db_datawriter roles in development databases so they can read and update tables in the database.
Greg
Greg
June 1, 2006 at 6:04 pm
If you know for a fact that they don't have INSERT privileges on the table, but can indeed insert records, another possibility, aside from the Role issue outlined above, is a stored procedure. If there is a stored proc for inserting records, they might have EXEC privileges on it.
June 2, 2006 at 7:22 am
Do you have other user roles to which the user may belong? We don't give any user permissions directly. All permissions are assign to roles we create, then the user is added to the appropriate roles.
In EM, what roles, if any have, INSERT permission? Does the user in question belong to that role? What about the Public role - any permissions there?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply