New owner with 'orig' owners permissions.

From: Roumen K (roumen_at_comcast.net)
Date: 05/28/03 

Date: Wed, 28 May 2003 10:35:24 -0700

Try this:
Create a script using EM for the database objects, users,
server logins and object level permissions (just in case -
specify only "Create object" under formatting options).
Open in the Query Analyzer and use 'Replace' to substitude
the user name with the new one you need to set up. Execute
only the commands for creating the login, user and
permissions.

Roumen K

>-----Original Message-----
>Hi all,
>
>I've got a problem I need help with. First, I've
restored a copy of a
>database into a new 'training' database. Now I want to
change the
>ownership of all tables to a new user, which I've already
created.
>The problem is that want to also transfer the individual
object
>permissions over to the new owner. These permissions are
very
>specific and vary object by object. The new object owner
will not
>have any of the original permissions if I simply change
ownership from
>the original to the new user. There are over 2000 tables
alone and
>I'm looking for a way to do this as easily as possible.
>
>Any ideas?
>
>Thanks very much for any help on this.
>
>-Mark.
>.
>

Relevant Pages

  • 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)
  • Re: Active directory corruption
    ... default web site and copied the permissions to all the child ... as it may not be the database that is the problem. ... prompt, use the ESENTUTL to check the integrity of the database. ... To recover the database type the following at the command prompt: ...
    (microsoft.public.windows.server.sbs)
  • 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)