I'll look into this. Thanks for the info Perry.

>SQL Server offers DMO (Distributed Management Objects) to allow for programmatic access to DBA type data.
>
>DatabaseRoles is a collection available under SQL 7 DMO. So you might be able to use this to add a user to a role.
>
>PF
>
>>I have been tasked with investigating the possibilites of configuring SQL Server security for users in an application programmatically on the fly. This would be quite new to me and I would like to get some counsel on the possibilities here, the pitfalls, etc. I'd appreciate input from anyone who has experience and/or is knowledgable on this issue.
>>
>>Thanks,
>>Bill