(OT) Special privileges to alter MS SQL Server SPROCS
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.
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.
Re: Special privileges to alter MS SQL Server SPROCS
created: 2006-05-04 11:13:19
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.
/J\
Re: Special privileges to alter MS SQL Server SPROCS
created: 2006-05-04 11:31:30
Win,
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.
Martin
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.
Martin
Re: Special privileges to alter MS SQL Server SPROCS
created: 2006-05-04 12:28:19
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?
Re^2: Special privileges to alter MS SQL Server SPROCS
created: 2006-05-05 04:22:34