Hi Group, Does anyone have an idea on how I could manage to do this?
Thanks Daniel > -----Mensaje original----- > De: Daniel Magliola [mailto:[EMAIL PROTECTED] > Enviado el: Monday, October 25, 2004 16:26 > Para: [EMAIL PROTECTED] > Asunto: [vbhelp] Stored Procedure Question - Permissions > > > > Hey group, > > I have a couple of questions (sent in separate mails, so we can keep > discussions apart) > > I have to get a list of all the Stored Procedures in a Database. > I'm currently querying the sysobjects database, and it works perfectly. > My problem is that I need to list only the SPs that the user has > permission > to execute. > > First I tested my app with user 'sa'. I get a list of all the SPs, and > everything works fine. > Then, I created a user that has NO permission at all, only permission to > execute 3 SPs. > > With that user, I still get the full list of SPs (I have no idea > how, since > I'd guess that user wouldn't have permission to read the sysobjects table, > but I don't really care much, as long as it works), but can only > execute the > ones he has permission to (as expected). > > My question is, how can I check if the user has permission to execute a SP > (being logged on as that user)? > I'd like to use a method that's "happier" than trying to execute > it, and if > there's no error, then I have permission, because that method > will be a bit > dangerous for the DB (in case it's an INSERT or UPDATE SP). > > Thanks a lot in advance. > > Daniel Magliola > Cimatic SRL > +5411 4787 5311 > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
