Viewing 9 posts - 1 through 10 (of 10 total)
Many thanks to all for your helpful suggestions. The user is still unable to run the application. Perhaps it is better this way. The app uses Excel to manipulate 2.5...
May 20, 2009 at 8:53 am
Yes, that is what I was saying, [JaneDoe].[whatever] is a tbale named "whatever" in the "JaneDoe" schema. That appears to be what it is trying to do.
Ok. Now I get...
May 12, 2009 at 10:23 am
Roy Ernest (5/12/2009)
May 12, 2009 at 9:44 am
RBarryYoung (5/12/2009)
May 12, 2009 at 9:38 am
Roy Ernest (5/12/2009)
You can run a profiler on the the Database to find out what Queries are executed.
Wow. Thank you! I had no idea the profiler existed or what it...
May 12, 2009 at 9:23 am
Roy Ernest (5/12/2009)
Why not try to give the db_ddladmin role to that user. Maybe that user does a Truncate command or Drop command or Alter command.
That's a possibility. I don't...
May 12, 2009 at 8:43 am
MarkusB (5/12/2009)
jblevins (5/12/2009)
MarkusB (5/12/2009)
Check also the default schema for the user.I'm not a trained DBA, so I've more than likely done this incorrectly. Her default schema is dbo.
That's the problem....
May 12, 2009 at 8:37 am
MarkusB (5/12/2009)
Check also the default schema for the user.
I'm not a trained DBA, so I've more than likely done this incorrectly. Her default schema is dbo.
May 12, 2009 at 7:06 am
RBarryYoung (5/11/2009)
Have you tried Granting here CREATE TABLE rights on the Database?
Yeah, that was one of the first things I tried. I should be so lucky as to have the...
May 12, 2009 at 7:03 am
Viewing 9 posts - 1 through 10 (of 10 total)