You can trap a SqlException and translate the error as desired in your code.
VB.Net WinForm example:
Try
sqlCommand.ExecuteReader()
Catch ex As SqlException
Dim PermissionError As Boolean = False
For Each sqlError As SqlError In ex.Errors
If sqlError.Number = 229 Then
PermissionError = True
Exit For
End If
Next sqlError
If PermissionError = True Then
MessageBox.Show("You don't have permission to select on this
table")
Else
MessageBox.Show("Unexpected error: " & ex.ToString())
End If
End Try
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Julie Barnet" <ba*****@pr.fraserpapers.com> wrote in message
news:43*************************@posting.google.co m...
Could someone please tell me how I can trap permission errors in
vb.net on a stored procedure:
ie. Execute permission denied on object 'sel_mytable', database
'mydatabase', owner 'dbo'
I would like to print a message like
response.write("You don't have permission to select on this table") as
opposed to the cryptic message I am receiving.
Thanks in advance
Julie Barnet