April 22, 2003 at 9:31 am
I have a user to whom I have granted the public, db_datareader, db_datawriter and db_ddladmin and db_owner roles. When I CREATE TABLE with this user and then check to see the permissions on that table, all the checkboxes for SELECT, INSERT, UPDATE, DELETE, etc. are blank. The user then cannot do anything with the table unless I specifically GRANT permission for him to do so. He created the table! Why can't he manipulate it with all those roles?
April 22, 2003 at 9:48 am
As long as 'dbo' is granted to this user, you don't have to assign other database roles. 'Public' is default for all users.
You may have two tables with same table name but different owner. When table is created with 'dbo' as owner, you will see not check in checkboxes for SELECT, INSERT, UPDATE, DELETE, etc. But if table is created with your user as owner, these boxes will be checked. In both way, the user will be able to perform any operations to the table because the user is the table owner.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply