Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permissions to execute sp_procedure_params_rowset Expand / Collapse
Author
Message
Posted Wednesday, September 1, 2010 10:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:56 AM
Points: 102, Visits: 319
Hi all!

I have an VB6 aplication which use system stored procedure "sp_procedure_params_rowset" via OLEDB to know the SP's parameters!

This works all good when running on new installation of SQL Server. The users that call the SP are members of Public Role.

I have installed the application at one existing server and I began to have an error because the recordset become empty!

After searching a lot I see that can be a problem with server role permissions (Public) so to try to have the same behavior I DENY EXECUTE TO PUBLIC and when I run the query manually I receive the empty recordset.

My doubt is, how can I discover why at the 2nd server I can't receive queries' results?

I allready see the Public Role permissions and I don't have any DENY to any object

Can you help me?

Best Regards,

CláudioSil
Post #978972
Posted Friday, September 3, 2010 2:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:56 AM
Points: 102, Visits: 319
Question answered!

At server's permissions scope I have an DENY VIEW DEFINITIONS!

As is normal within the database will not have permissions to view the metadata of the system SP!

But if users in the database has db_owner ROLE associated, this restriction no longer exists!
Post #980073
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse