how to export role from one database to other

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I have to assign a role from one database to the user in other database. How to assign a role of a particular database to user in some other database

Regards, Raja V

-- Anonymous, April 11, 2003

Answers

Raja,

I don't understand the question. A role is essentially a set of users. The set represented by the role can be granted certain access to certain databases. As a consequence, the members of the role will all then have the accesses that have been granted to the role.

You therefore confuse me when you say, "I have to assign a role from one database to the user in other database." The closest I can come to parsing your question is, "How do I add a user to a role?" The answer to that is: With the sp_addrolemember command.

Hope this helps,

Eric

-- Anonymous, April 14, 2003


Moderation questions? read the FAQ