Re: Create Login like another login...
- From: "Joe Yong" <NO_joeyong_SPAM@xxxxxxxxxx>
- Date: Sat, 8 Jul 2006 01:33:41 -0700
That's a pretty old script you're using and it's written for SQL Server
2000, calling objects in the master database.
You can update the script using some of the security catalog views instead
of tables in master. For example, fn_my_permissions will tell you what
effective permissions the current user has.
As for the error message below, it looks like you probably had a typo
somewhere when creating or running the sproc. Probably a datatype mismatch.
joe.
"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CFECA19B-9C34-4D52-B9FC-1FA95817EE78@xxxxxxxxxxxxxxxx
One bit of functionality I like in Oracle's Enterprise manager, that I
haven't located in SQL Server is the ability to create a new login with
all
the same rights, roles etc of an existing user.
I am using SQL Server 2005. I have tried
USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LOGIN written by GREG LARSEN, but I
get
an error when executing it.
==================
Msg 213, Level 16, State 7, Line 2
Insert Error: Column name or number of supplied values does not match
table
definition.
==================
Does anyone point me to a way of doing this?
Paul
.
- Prev by Date: Re: Remove/Add BUILTIN\Administrators 2000 sp4
- Next by Date: Re: Hide SQL Server DB
- Previous by thread: securityadmin
- Next by thread: Windows NT user or group "XX" not found
- Index(es):
Relevant Pages
|
