I am using ASP with SQL server backend and I have some Users for a database.<BR><BR>I am using the following lines of code to check the UserID and Password.<BR><BR>&#060;% set cn=server.createobject("ADODB.connection")<BR> cn.open "driver={SQL server};SERVER=MyServer;uid=browser;pwd=sie;DATABA SE=ASPBOOK"<BR>%&#062;<BR><BR>If a wrong UserID tries to log-on to the system an SQL Server error occurs and I have handled the error in my Error handling routine.<BR><BR>Now I have some roles on SQL Server(db_datareader, db_backupoperator) assinged to each user.<BR>In the connection string in the about lines of code, can I pass even the Roles also or if a user<BR>has a role = db_denydatareader (assinged in SQL Server), will the error occurs?<BR><BR>How do we pass the roles in ASP or is it not necessary at all.<BR><BR>Kindly someone give me some ideas.<BR>Thank You<BR>Nath