Hello,<BR><BR>I want to find out if there is any system stored procedure in SQL server 7.0, which will get the Permissions of a Logged on user (database roles of a user). So that If the logged on user has the role of "db_datareader", I will not allow the user to write anything into the database through my ASP application.<BR>Any help is appreciated.<BR>thank you<BR>basamnath@aol.com<BR>