|
have
you tried giving the CF user permission to the tables/db? Whenever I create a
new table/view etc, I always need to give the CF user permission to it, else I
get an ODBC error, access denied.
-steve
Hi folks:
Sorry if this is a little
off-topic but I figured since it's a Cold Fusion list, a good chunk of you
would at some point have experience with SQL Server (I'm using 2000) and could
answer this question for me.
I got a copy of a database which has many tables,
the problem is they are "owned" by a user which doesn't exist on the system I
attached. Therefore, CF can't pull any data (doesn't have permissions) and all
the data I need of course is on the table owned by the user created on the
last system it was on.
How do I change permissions? I've tried
everything logical, from detaching it, creating a user on the system (both
just the database, then on SQL server, then a user on the actual NT domain,
none worked!) I've tried editing the sysusers table to no avail, anybody been
stuck on this before?
Take care
Sean
|
