RE: [CF-Dev] SQL permissions

["Russ Michaels \(Snake\)" <snake.lists@snakepit.net>]

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: dev-bounces@list.cfdeveloper.co.uk
[mailto:dev-bounces@list.cfdeveloper.co.uk] 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