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: 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)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)