Add another db to a login

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

ramakrishna100 SSC Veteran Points: 216 More actions · Answer 1

You can use sp_grantdbaccess procedure.

1) Login as sa or dbo

2) USE HisDB

3) EXEC sp_grantdbaccess 'Cris', 'Cris'

Thanks

Regards

Ram

Andy Warren SSC Guru Points: 119902 More actions · Answer 2

SP_grantdbaccess is the preferred method. If you look at sp_addlogin it just in turn calls sp_grantdbaccess.

Andy

Cristina Grasshopper Points: 14 More actions · Answer 3

Thank you for your answers. I solved my problem with sp_grantdbaccess.