DB_OWNER and the Drop Database issue

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

  • Re: DB_OWNER and the Drop Database issue
    ... db_datareader,db_datawriter database roles in the BOL ... I have a 3rd party software that needs to create/alter/drop tables within ...
    (microsoft.public.sqlserver.security)
  • Re: How can we detach /attach database in program?
    ... > Can we detach /attach database in program? ... Do you mean Create/Alter/Drop? ... Cor ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Shell Command
    ... >> Using a Access2003 database in WinXP I am trying to shell over to a third ... >> The 3rd party software is installed in the same directory as the ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.externaldata)
  • Re: Most performant way to code client script.
    ... >> I would usually not try to do serious scientific computing within the ... Usually the 3rd party software you are using will employ a highly ... If you are lucky it will fetch the data itself from the database, ...
    (comp.databases.oracle.server)
  • Re: Problems with Shell Method
    ... > The 3rd party software is installed in the same directory as the database. ... Is there a way to shell to a desktop shortcut? ...
    (microsoft.public.access.formscoding)