>- see footer for list info -< Just for reference, this was asked on behalf of a client. He was not prefixing his DB calls with the username, which you must do if they are not DBO owned objects you are calling. Russ
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russ Michaels (Snake) Sent: 29 September 2004 15:39 To: 'Coldfusion Development' Subject: [CF-Dev] SQL permissions Having a weird problem... got 2 users on a database USER1 and USER2 Want to give USER2 permission only to execute a couple of stored procs. So I create dthe SP's (owner is USER1), and gave USER2 execute permissions. But he still can't execute them. I also tried giving USER2 permissions on various tables, and he cannot view those either. Any idea why ? Russ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
