Post reply

Script out logins permissions

  • October 27, 2016 at 11:38 am

    #331447

    Experts, time to time, I refresh DBs from Prod to Dev or QA servers. In prod, all users have read only access but in dev or QA, they have R/W. So when I refresh the DB from Prod, I always have to grant write access to users. Are there any scripts which can help me script out all logins with all permissions users have on Dev or QA servers?

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • October 28, 2016 at 2:19 am

    #1909308

    Take a look at sqlstudies.com[/url]. Kenneth Fisher has nice scripts under the "Free Scripts" menu to script out all instance or all database permissions.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply