Re: DB_OWNER and the Drop Database issue

Jonas
You can add this user to dbcreator fixed role. See
db_datareader,db_datawriter database roles in the BOL


"Jonas Larsen" <JonasLarsen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E2D180F4-4FBF-4006-9256-CDA0F3C85104@xxxxxxxxxxxxxxxx
Hello

I have a 3rd party software that needs to create/alter/drop tables within
a
database. So to do this I have added the application user to the db_owner
database role, however the problem the arises that through the application
a
user can actually delete the database it self - and will do so with out
any
consideration to what ever else is in this database.

Is there another way of giving a user the ability to create/alter/drop
tables plus read/write data other than through the db_owner?

Thanks.

Regards
Jonas


.

Relevant Pages

  • DB_OWNER and the Drop Database issue
    ... I have a 3rd party software that needs to create/alter/drop tables within a ... database role, however the problem the arises that through the application a ... Is there another way of giving a user the ability to create/alter/drop ... tables plus read/write data other than through the db_owner? ...
    (microsoft.public.sqlserver.security)
  • Re: Restricting access to one application and still use database roles?
    ... manage different access levels within the database/application with ... database roles. ... access to the database should be restricted ... because it destroys the database roles. ...
    (microsoft.public.sqlserver.security)
  • Scripting help
    ... The attached script is intended to verify that a database exists, ... and adds database roles with a twist. ... executing 'USE ' and discovered that this command does nothing ...
    (microsoft.public.sqlserver.server)
  • Re: OLAP (Analisys Services) from .NET for WebPages
    ... what are the database roles, ... >perhaps Database FoodMart don't exist ... >> I want to connect to Analisys Services Database ...
    (microsoft.public.sqlserver.olap)
  • Re: Roles
    ... right click in the source database and choose All Tasks->Generate SQL ... database users and database roles". ... Now run the resulting script in the destination database. ... > How to move the roles in db from one server to a different ...
    (microsoft.public.sqlserver.security)