Performance and permissions

From: Vance Kessler (vkessler@peachtree.com)
Date: 01/24/03


From: vkessler@peachtree.com (Vance Kessler)
Date: 24 Jan 2003 04:39:30 -0800


I have a stored procedure that will run in 39 seconds for a low
permissions user but will execute in just 3 seconds when I add that
user to the 'System Administrators' role. Does anyone know why this
would happen? Is there a way to correct this without adding them to
the admin group?

Thanks
Vance


Quantcast