Determining SQL Server user's permissions from ADQ

[mikecarter]

How can I determine whether a user has read-only or read-
write access to a database when I connect to it using ADO?

I am hoping to find a more elegant solution than just
attempting to modify data in a particular table and
checking for errors.

I have tried to use the "mode" property of the Connection
and Record objects, but to no avail.

This is running against a MS SQL Server, and we are using
local SQL server login accounts (not NT domain accts).
This for an ASP script, if that matters. I basically want
the user to see an updatable form if their logon
credentials have read-write access to the DB, or simply
see a plain-jane table of the data if their credentials
have read-only access to the database.

I am fairly new to ADO. Thank you for your help!

 

[palbano]

Have you looked at the SQL Server stored procedures? You might ask your question in the SQL Server forum. If you can't read the permissions though a stored procedure then you can't do it from ADO ;-)


-pete
_{I just can't seem to get back my IntelliSense}