SQL Server - Table Permissions

[pwel]

Hi,

Is there any way, using asp, that I can test whether a user has permissions on a certain table in an SQL Server db.

I.E. Before i do a select on (myTable)

I wish to check that the current user has permissions to select from (myTable)?

Cheers in advance.

PW.

Paul Welding
Web Developer

 

[shaddow]

Use connection object to connect to database with an user and pwd that you have

'turn error trapping on
On Error Resume Next

Conn.Open "..."
If Err.number <> 0 then
'we have an error wich means that user cannot access the database
end if

'turn error trapping off
On Error Goto 0

You can check to see what is the error number when an user has no right over an database.

________
George, M