Re: User permissions

From: Adi Cohn (adicohn@hotmail.com)
Date: 11/11/02 

From: "Adi Cohn" <adicohn@hotmail.com>
Date: Mon, 11 Nov 2002 17:20:01 +0200

  I don't think that it always should be a dbo even if the user should have
access to all objects. It is one thing to give the user permission to
delete all rows, but it is a different thing to give the user permissions
to drop tables, restore database, change other users' permissions etc'.
I think that it is better to add them to db_datareader and db_datawriter
roles in the database and also give them permissions to run all stored
procedures in the database.

Adi

"Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
news:ePI6UCZiCHA.1516@tkmsftngp09...
> If they need access to all the permissions for all the objects then it
> sounds like they should be a dbo.
>
> --
> Andrew J. Kelly SQL MVP
> Targitinteractive, Inc.
>
> Check out the PASS Community Summit - Seattle, the largest and only user
> event entirely dedicated to SQL Server, November 19-22.
> http://www.sqlpass.org/events/seattle/index.cfm
>
>
> "Chris Themistocli" <cthemistocli@aw.com.cy> wrote in message
> news:122d01c2898c$8006c7f0$8cf82ecf@TK2MSFTNGXA07...
> > Is there a transact-sql or other way that I can use to
> > grant permissions to all objects in a database to a
> > specific user? The only way I could find is to go through
> > all objects (tables, stored proc and views) by using the
> > Enterprise Manager.
>
>

Relevant Pages

  • Re: How to prevent DELETEs in a table
    ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
    (microsoft.public.sqlserver.server)
  • Re: Delegate Power of God to only 1 database - How?
    ... Guess I'll have to look more closely at the permissions ... >I support the Professional Association for SQL Server ... >> permissions to only that database which can be assigned ... >>>Exactly what is this 'dBO' role you are referring to? ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Re: Active directory corruption
    ... During an installation of PHP I accidentally changed permissions for the ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.sbs)