Re: User permissions

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 11/11/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Mon, 11 Nov 2002 09:44:02 -0500

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

  • Problem is w/ .ADP..Re: SQL db Permissions for users not working
    ... You do not have SELECT permissions on the ... SysObjects system table in the database. ... figured out that qualifying the database owner (dbo in my ... >> I feel that the object owner is not dbo, ...
    (microsoft.public.sqlserver.security)
  • Re: public role question
    ... If 'select user' is returning DBO, it means you are connecting AS DBO, and ... testing the permissions the new user has. ... Are you saying that the permissions to create the stored procedure are ... Dan D. ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent DELETEs in a table
    ... What you say about dbo is true, but it is even MORE true about someone who ... is in the sysadmin role. ... No permissions are ever checked for someone in the ... the deny is not applied. ...
    (microsoft.public.sqlserver.server)
  • 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: Control over creation of procs & views owned by dbo
    ... To add on to Jasper's response, you could also change object ownership to ... 'dbo' with sp_changeobjectowner. ... security context of the invoking user, not the object owner. ... need permissions on only directly referenced objects. ...
    (microsoft.public.sqlserver.security)