Performance and permissions
From: Vance Kessler (vkessler@peachtree.com)
Date: 01/24/03
- Next message: Raj Bhaskar: "Re: Allowing only certain clients access to SQL Server 2K"
- Previous message: Dejan Sarka: "Re: Prevent Client from Connect without My Application"
- Next in thread: SQL Server Development Team [MSFT]: "Re: Performance and permissions"
- Reply: SQL Server Development Team [MSFT]: "Re: Performance and permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Raj Bhaskar: "Re: Allowing only certain clients access to SQL Server 2K"
- Previous message: Dejan Sarka: "Re: Prevent Client from Connect without My Application"
- Next in thread: SQL Server Development Team [MSFT]: "Re: Performance and permissions"
- Reply: SQL Server Development Team [MSFT]: "Re: Performance and permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]