user mapping

Question

Post reply

user mapping

mike 57299

SSCrazy

Points: 2529
More actions
July 14, 2010 at 3:50 pm

#235313

Please view the attached picture and tell me how to script setting the sv2 user to 'map' to the solovue_country_fresh database with a role membership of db_owner.
Thank you!!
Mike

Viewing 7 posts - 1 through 6 (of 6 total)

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

Did you consider BOL (BooksOnLine, the SQL Server help system), section "sp_addrolemember" as a resource?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Steve Jones - SSC Editor SSC Guru Points: 736210 More actions · Answer 2

Everything's kinda on that screen. I think you ought to try this yourself first and if it doesn't work, let us know what you've done.

mike 57299 SSCrazy Points: 2529 More actions · Answer 3

Everything is on that screen is UI. I want to know how to do it in an .SQL file that can be run.

Mike

Minaz Amin SSChampion Points: 11052 More actions · Answer 4

Try the SP_ADDROLEMEMBER TSQL

EXEC SP_ADDROLEMEMBER N'db_owner', N'user_login'

"More Green More Oxygen !! Plant a tree today"

mike 57299 SSCrazy Points: 2529 More actions · Answer 5

Ok...

This:

use xyz

EXEC sp_grantdbaccess @loginame = 'sv2'

gets me 'public' database access to xyz for user sv2. How do I programatically get the db_owner set for the same user?

TIA,

Mike

vkundar Hall of Fame Points: 3431 More actions · Answer 6

mike 57299 (8/6/2010)
Ok...
This:
use xyz
EXEC sp_grantdbaccess @loginame = 'sv2'
gets me 'public' database access to xyz for user sv2. How do I programatically get the db_owner set for the same user?
TIA,
Mike

What privileges with you have logged in? if it is a sysadmin and simple from the management studio you can assign db_owner role on the specific db for the login you need. This will be the simple step

or use the TSQL above to grant the role.

Cheers,

Got an idea..share it !!

DBA_Vishal