Moving Users from one server to another in 2005

27 Jul 2006 8:53 PM

Jim

Is there an easy way to script out all of a users permissions (at all
levels)?

I have a user on a dev database on Server1 that I want to move to a
test database on Server2. I would like to have something that would
create a script of all that users permissions. At the server level, at
the database level, and at the schema level.

I have played with the scripting option of Management Studio, but can't
seem to get it to do that. When I tell it to script one user and
select object level permissions, all I get is the Create User
statement.

It does not mention that he is in Schema A and that Schema A has the
following permissions. Or that he has Create Procedure rights at the
database level.

Am I doing something wrong here. Isn't that the kind of information a
DBA would need to recreate a user on a different server? Please help.

Thanks.

Jim

28 Jul 2006 3:35 AM

Uri Dimant

Jim
Search on internet 'sp_help_revlogin' system stored procedure provided by MS

Show quote

"Jim" <jdyoum***@gmail.com> wrote in message
news:1154033615.797315.85920@m79g2000cwm.googlegroups.com...
> Is there an easy way to script out all of a users permissions (at all
> levels)?
>
> I have a user on a dev database on Server1 that I want to move to a
> test database on Server2. I would like to have something that would
> create a script of all that users permissions. At the server level, at
> the database level, and at the schema level.
>
> I have played with the scripting option of Management Studio, but can't
> seem to get it to do that. When I tell it to script one user and
> select object level permissions, all I get is the Create User
> statement.
>
> It does not mention that he is in Schema A and that Schema A has the
> following permissions. Or that he has Create Procedure rights at the
> database level.
>
> Am I doing something wrong here. Isn't that the kind of information a
> DBA would need to recreate a user on a different server? Please help.
>
>
> Thanks.
>
> Jim
>

28 Jul 2006 1:59 PM

Jim

I have. It will create the logins but not the permissions. Even the
updated one for 2005 just uses the new create user syntax.

It does not make sense that there is not something out there that will
give me what I need.

Anyone?

Jim Youmans

Uri Dimant wrote:
Show quote

> Jim
> Search on internet 'sp_help_revlogin' system stored procedure provided by MS
>
>
>
> "Jim" <jdyoum***@gmail.com> wrote in message
> news:1154033615.797315.85920@m79g2000cwm.googlegroups.com...
> > Is there an easy way to script out all of a users permissions (at all
> > levels)?
> >
> > I have a user on a dev database on Server1 that I want to move to a
> > test database on Server2. I would like to have something that would
> > create a script of all that users permissions. At the server level, at
> > the database level, and at the schema level.
> >
> > I have played with the scripting option of Management Studio, but can't
> > seem to get it to do that. When I tell it to script one user and
> > select object level permissions, all I get is the Create User
> > statement.
> >
> > It does not mention that he is in Schema A and that Schema A has the
> > following permissions. Or that he has Create Procedure rights at the
> > database level.
> >
> > Am I doing something wrong here. Isn't that the kind of information a
> > DBA would need to recreate a user on a different server? Please help.
> >
> >
> > Thanks.
> >
> > Jim
> >