Drop Database

B

Bob

What is the best / correct way to prevent a user from being able to drop the
database?
thanks in advance,
...bob
 
B

Belu33fr

In Sql managment security connexion, create an user and dont give a role on
the server to this user, give the access to your database and in the your
database, grant acl to this user (or more simply, register this user in a
group witch has the rights you want).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restrict Choice in Shared WB (drop down alternative)? 0
Can't drag in drop to create a query 0
Data validation or drop down lists 4
Populate list or combo box from closed workbook 4
Copy record in one form into a new pop-up form 0
Link, drop link, relink 2
Form as OLE drop target - possible or not? 1
Can Access do this? 3

Top