Stored procedure - permissions

From: John J. Hughes II (no_at_invalid.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 10:50:41 -0400

Ok I have a zillion stored procedures with meaningful names, wow! I can now
set user level permissions, double wow!

Ok there does not seem to be a easy way of doing this in the enterprise
manager. The base way I have found is to open the user name and then click
each stored procedure "exec" check box which is way slow. In the stored
procedure window you can select more then one stored procedure but you can
not set permissions for more then one SP at a time so...

Is there a better way?

Assuming I am correct and there is not a better way from Enterprise manager
can someone tell me how to do it from SQL command so I can write a function
myself? I can get all the procedures and sort them but I am missing how to
set the user level permissions.

Regards,
John

Relevant Pages

  • Re: SQL Server returning Empty Fields and there should be data
    ... 2K (Win2K Server Machine), I use a Stored Procedure to handle getting the ... For example, in the two lines above, the Project Input box would ... to open the SP in Enterprise Manager or MS Access, ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL Server 2005 - Cant edit results from stored procedure
    ... > then run a stored procedure that returned data from a 2 table select ... > statement and edit the data. ... I don't use Enterprise Manager much but I'd be surprised if it's possible to ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: DTSRun from SP
    ... To create a job and schedule the stored procedure in ... Enterprise Manager, go to Management, SQL Server Agent and ... Create a T-SQL job step to execute the stored procedure. ... >where do i look for the job or the code in enterprise manager ...
    (microsoft.public.sqlserver.dts)
  • Re: stored procedures in vb6 und sql server
    ... > eigener benutzeroberfläche anmeldepasswörter am sql-server ändern zu können ... > selbstständig ohne enterprise manager ändern können). ... die stored procedure wird am besten mit dem Enterprise Manager ...
    (microsoft.public.de.sqlserver)
  • Re: output parameter T-sql doesnt work
    ... out-of-range smalldatetime value. ... Stored Procedure: Asset.dbo.prStoreOrder ... I've literally copied the insert into statement from enterprise manager, ... The message about char data to smalldatetime sounds ...
    (microsoft.public.sqlserver.server)