Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

(OT) Special privileges to alter MS SQL Server SPROCS

by Win (Novice)
on May 04, 2006 at 14:37 UTC ( #547421=perlquestion: print w/replies, xml ) Need Help??
Win has asked for the wisdom of the Perl Monks concerning the following question:

How do I get MS SQL Server 2000 to demand special privileges to alter SPROCS but at the same time maintain the possibility of Perl DBI execution of SPROCS from Perl programs running locally?

Update: In addition, I would quite like a Perl script that would detect tables that have had internal duplications and detail them to the administrator. I'm not quite sure of the approach to take with that.
  • Comment on (OT) Special privileges to alter MS SQL Server SPROCS

Replies are listed 'Best First'.
Re: Special privileges to alter MS SQL Server SPROCS
by gellyfish (Monsignor) on May 04, 2006 at 15:13 UTC

    You should really read the documentation for the SQL Server permissions system and specifically the parts about permissions in the ALTER PROCEDURE and the discussion of stored procedures in GRANT. This has no specific relevance to accessing the database using the DBI. I would suggest you take your SQL Server questions to somewhere interested in SQL Server after, of course, you have read the documentation.


Re: Special privileges to alter MS SQL Server SPROCS
by marto (Bishop) on May 04, 2006 at 15:31 UTC

    To echo some of what gellyfish has said, read the documentation. You have been advised to do this (regards MS SQL Server questions you have asked in the CB) many times by many different monks. You did not do it then, so I have no confidence in you reading up on this topic now. This has happened for various technologies you have posted questions about and asked about in the CB. Again your asking for advice that, historically, you have not taken.

Re: Special privileges to alter MS SQL Server SPROCS
by blazar (Canon) on May 04, 2006 at 16:28 UTC

    I don't know anything about these topics. So maybe you could help me to understand: how does this question of yours really differ from that of this post of yours?


      If you look at some of Win's previous posts it is often the case that he will re post a question if he is not happy with the answers or advice he is given in reply to a previous post of the same question, or if he does not understand the advice or is unwilling to take it.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://547421]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (6)
As of 2017-05-26 02:11 GMT
Find Nodes?
    Voting Booth?