Permission

From: Julia (Julia_at_discussions.microsoft.com)
Date: 08/15/05 

Date: Mon, 15 Aug 2005 03:59:02 -0700

Hi,
I have a database user in my SQL-server (a server I use for test and
development). This user has some select and update permissions on some
tables. Is it possible to make a script or anything else so that the database
administrator for the original database doesnt have to edit all permissions
one by one?

Thanks
julia

Relevant Pages

  • Re: SecurityAdmin server role
    ... Add that login to that partcular database as a database user and assign ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: 50 and more servers, 200 and more datyabases, HOW TO list USER
    ... -extract each database user ... "Keith Kratochvil" wrote: ... It's borrying to use Enterprise Manager, connect each server, each ...
    (microsoft.public.sqlserver.tools)
  • Re: securityadmin
    ... add the database user to db_datareader, ... fixed server role Security Administrators. ... I can go ahead and add that login as a database user and add them ...
    (microsoft.public.sqlserver.security)
  • EJB3.0 Entities and database password control
    ... impressed by the apparent simplicity that the use of entity beans ... the backend database. ... Rather than a single database user, I want to have one of the ... connection between my entities and the database happens as if by ...
    (comp.lang.java.databases)
  • Re: SQL Users (Basic Question)?
    ... A login is stored in the master database. ... ability to connect to the SQL Server. ... A database user allows a login to use a particular database and the entry is ...
    (microsoft.public.sqlserver.security)