Re: Enterprise Manager and Windows Account

From: Tabassum Khan (tabassum@sys.net.pk)
Date: 12/03/02 

From:     Tabassum Khan <tabassum@sys.net.pk>
Date: Tue, 03 Dec 2002 02:27:18 -0800

giving "db_owner" rights to the new user gives him complete control of
the database.

is there any work around?

one possible solution that i m thinking of is:

--make an application role
--add permissions to it (create table etc.)
--write restore code in VB program
--deny create table permission to the user

in my opinion, this will prevent the user from restoring that DB from EM
and Query Analyzer

is that possible???
any insight will be highly appreciated

regards
Tabassum

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: VS 2008 Data Access Issues
    ... The permissions you have to watch are the permissions for the account that ASP.NET runs under. ... The reason for write on the folder is the lock file is created when someone opens the database file, even from a website. ... The datanavigation control shows no records either and when I attempt to add a record it is not saved. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ODBC Driver error
    ... > What database are you using? ... set Everyone Full Control on ... > directory where it resides, as a test, as well as your TEMP/TMP ... >> read permissions on the table. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Can I Set permissions for a .mdb using Windows login?
    ... Just to clarify. ... While that will limit who can access the database, it won't control what ... are desired in terms of permissions for those who can access the database ...
    (microsoft.public.access.security)
  • Submitting Information To Access
    ... Check your permissions and make sure you are granting ... full control to the database. ...
    (microsoft.public.frontpage.programming)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)