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 ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/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/
