how to export role from one database to othergreenspun.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 databaseRegards, Raja V
-- Anonymous, April 11, 2003
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