Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

(OT) Setting up SPROC permissions from a code snippit - Is it possible?

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

Dear Monks,

Is there anyway I can set MS SQL Server stored procedures so that they can only be activated by another stored procedure and can not be activated from an outside Perl DBI call? I would quite like to be able to set up a condition like this through use of a Perl code snippet? I have googled to try to get an answer but without too much luck.

Update A: What I am really looking for is a sproc path tracker with the capacity to set requirements for execution paths prior to a SPROC being activated. Is it feasible for such a thing to be programmed using SPROCS and a Perl coded interface?

Update B: Maybe I am jumping ahead of myself here. I should start by asking whether there is a means of calling MS SQL Server object dependencies using Perl.

2006-04-26 Retitled by planetscape, as per Monastery guidelines
Original title: 'Setting up SPROC permissions from a Perl snippit - Is it possible?'

Comment on (OT) Setting up SPROC permissions from a code snippit - Is it possible?
Re: (OT) Setting up SPROC permissions from a code snippit - Is it possible?
by Fletch (Chancellor) on Apr 25, 2006 at 14:19 UTC

    Is there anyway I can set my car's radio presets so that they can only be changed by the primary driver and can not be activated by another driver? If so, can a condition like this be enforced or set up through use of a Perl code snippet? I've not really googled to try and get an answer because it's a FRELLING STUPID QUESTION WHICH HAS NO REAL RELEVANCE TO PERL JUST LIKE EVER OTHER FRAKING QUESTION Win ASKS HERE.

    //
    // End std_annoying_question_from_win.h
    //
    

      Why don't you wait for any interesting replies that people have before making posts like this.

        Perlmonks is not your personal clue reserve. You've shown again and again an unwillingness to listen to good advice even when you've asked marginally relevant questions. You've shown again and again a marginal grasp of what's a Perl problem, and what's a basic programming problem that 5-10 minutes with an introductory text would clear up. You've shown again and again that you have no desire to stay on topic with your questions.

        Many people think you're not contributing anything useful here (c.f. your posts' regular appearances in Worst Nodes), it's not just me. If you have reasonable questions about Perl, by all means post them and people will gladly help (well, not me because your bozo bit is pretty much permanently set as far as I'm concerned; but I'm sure there's some forgiving souls that will give you another chance). But otherwise, give it a rest. Adding "Is there a way to do this with Perl" to every fraking obstacle you happen to come across doesn't make it a Perl problem.

Re: (OT) Setting up SPROC permissions from a code snippit - Is it possible?
by gellyfish (Monsignor) on Apr 25, 2006 at 14:46 UTC

    The MS SQL Server permissions system is fully document in the T-SQL Reference - as ever it is immaterial which language you might want to use to interact with the database.

    /J\

      By right clicking on sproc icons in a MS SQL database it is possible to see the dependencies that each stored procedure have. You can see first or multi-level dependencies for objects that depend on the sproc in question and objects that the sproc depends on (apologies to those that do not have MS SQL Server 2000). I wish that I could use these dependencies and set requirements. ie. For example, I may wish to set a requirement that this, this and that sproc is activated before the subject sproc is activated. This to me is different from granting permissions to a MS SQL object. If this assumption is correct and there is no in built MS SQL solution to this issue, then maybe a Perl solution is called for.

        You are completely misunderstanding the notion of 'dependency' in the database. You probably want to read the description of the sp_depends system stored procedure. Please take some to read the documentation for SQL Server, something you have been exhorted to do many times.

        In short what you are suggesting cannot be done, the only method of controlling access to stored procedures is through the granting of permissions. Again, it is immaterial which language you might be using above the database level.

        /J\

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://545565]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (10)
As of 2014-12-22 12:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (117 votes), past polls