SQL Server Security?

[Nathan]

I have two groups that have different access to my SQL Server database... One group can only read while the other can read or write. I want to be able to determine which type they are when the app starts to determine how the program will run.

Is there a way to connect to the database and then check to see what kind of permission the person logged into the database has?

[jdavison]

there is away to set permission in sql server(dont exactly remember how at the moment). You can create users with specific permisions and then use the accounts in the connect string. In enterprise manager for sql server, if you look under security for that DB server you can see logons which is where you can create those accounts. when you create those accounts you can use those for the user id and passwrod in the connect string.