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?