Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of dbaSQL
dbaSQL🇺🇸

sp_help_revlogin AND user id's
I've used sp_help_revlogin forever, whenever I need to move logins from one machine to the next.  I am trying to strengthen/refine/improve my security management, and I am wondering if somebody can help me take this a step further.

it's not just a matter of creating the logins.  it's also creating the associated database users and roles, AND the object permissions.

I have a lot of individual scripts that allow me to script out permissions based on user or roles.  But, i'm looking for something that may help me approach this a little more broadly, at the database layer.

Again, i am just in the process of cleaning up all my admin scripts -- right now i'm looking at the security model specific to each database.  That is the logins, the users and roles, and the related permissions.

Does anybody have a means of mass-scripting this sort of thing, maybe by database?  And if not 'mass-scripting', surely there is a cleaner means of doing this than what I've got.  (right click object, generate script w/permissions, then re-use, as needed... yuck)

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of dbaSQLdbaSQL🇺🇸

ASKER

this is very cool, but not compatible with v2000.  does anybody know of anything similar?
http://www.sqlservercentral.com/Forums/Topic453290-146-2.aspx

Avatar of dbaSQLdbaSQL🇺🇸

ASKER

how about sp_helprotect?  if i could find a means of getting this, and then PRINTing out the actual permission granting.  

ASKER CERTIFIED SOLUTION
Avatar of dbaSQLdbaSQL🇺🇸

ASKER

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.