What permissions do I have on my SQL 2005 database?

The following article explains the permissions given to your SQL 2005 database. When the database is created, a user is configured with the following permissions:

• db_datareader - allows the user to view the database and perform SELECT statements on the database
• db_datawriter - allows the user to create and modify tables and perform INSERT, UPDATE, and DELETE statements on the database
• db_ddladmin - allows the user to create and drop tables in the database

The permission for complete ownership of the database, db_owner, is no longer given in order to ensure the security of the database and server.

When connecting to your database through SQL Management Studio, you may see the following error message:

This message simply means that you do not have full ownership of the database. Since db_owner is no longer used, you can ignore this message.