looks weird for me too... So, I created this account on my server to test. I have attached the scripts above too...
The user is SQL Authenticated DB user
I am confused. In my example, the user does not have access to the objects, but executing the SP with his privileges (EXECUTE AS CALLER) and still,...
Thanks Luis. I did a check with sample table... I created a stored proc AccessTestTable that does a select to the table TestTable. I created a...
I am trying to assign execute permissions to users on a stored proc. The users do not have read permissions on the tables called inside the SP. When...
Thanks Luis. I got a way from Quest Support. We can call the Litespeed Extended Stored Procedures (xp_backup_database, xp_restore_database) from the...
Hi, I wanted to know if I can access the LiteSpeed features (primarily backup/restore) from a .NET Application I develop. Does LiteSpeed provides...
Separate names with a comma.