December 28, 2005 at 12:37 am
I am a novice at SQL Server Administration.
Here is the question.
After I create a table, how do I set it so that no one can DELETE the table?
I see where I can restrict the deletion of records etc., but I want to prevent the possibility of DROPPING the table.
I am certainly new to the "permissions" portion of this.
Thanks, in advance, for your assistance.
December 28, 2005 at 1:00 am
By giving db_datareader permission to the user who is accessing the table
then readonly permissions will be assigned to the table.
December 28, 2005 at 5:12 am
The roles that can DROP a table are DBO, DDL_Admin, obviously the SA login and other members of the SysAdmin role.
Provided your user is not a member of such roles they will not be able to DROP the table.
db_DataReader grants readonly permissions to ALL tables in a database, even the system tables so be wary of this role.
Everyone is a member of Public so anything you do to the Public role will affect every user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply