[CF-Dev] SQL permissions

To: "'Coldfusion Development'" <dev@list.cfdeveloper.co.uk>
Subject: [CF-Dev] SQL permissions
From: "Russ Michaels $Snake$" <snake.lists@snakepit.net>
Date: Wed, 29 Sep 2004 15:38:44 +0100
In-reply-to: <001101c4a628$811f20a0$327ba8c0@DELL>
List-archive: <http://list.cfdeveloper.co.uk/pipermail/dev>
List-help: <mailto:dev-request@list.cfdeveloper.co.uk?subject=help>
List-id: Coldfusion Development <dev.list.cfdeveloper.co.uk>
List-post: <mailto:dev@list.cfdeveloper.co.uk>
List-subscribe: <http://list.cfdeveloper.co.uk/mailman/listinfo/dev>, <mailto:dev-request@list.cfdeveloper.co.uk?subject=subscribe>
List-unsubscribe: <http://list.cfdeveloper.co.uk/mailman/listinfo/dev>, <mailto:dev-request@list.cfdeveloper.co.uk?subject=unsubscribe>
Reply-to: Coldfusion Development <dev@list.cfdeveloper.co.uk>
Thread-index: AcSmKCAPWNfID5twQc2mmZjf33J0tAACZqpg

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