I found it...

GRANT CREATE TABLE TO user

GO

GRANT CREATE VIEW TO user

GO

Thank you so much for your response!

Very cool for only one column within a table. What about multiple? I see this is becoming a huge project now :(.

Thank you so muhc for your help!

They are set exactly the same. I actually took the dev script and ran it in production and it works fine in prod, not in dev. Now, this is a...

Yes, I apologize I thought I added it.

Message

Error: 18456, Severity: 14, State: 11.

Thank you. I'm going to try creating a schema for the group to see if that works somehow. We have a 3rd arty tool but not for all members. Let's...

We don't need to use a proxy, we have one server, not on a cluster on SQL SErver 2005 32bit in which it works (same settings, same rights) and...

The proxy is an admin on the box as well as sa on sql server.

I am not sure I understand what you are saying. However, I created a sql user and give it direct permissions to execute on sp_start_job and that stilli gives the...

It is to give developers access to run a job. Our old dev server allows them to, with exact same settings. This new one. does not.

The proxy account is set up the same way on another server. The old server on v3257 works but new server on 4035 does not work.

Good idea. thanks!

Yes. It is to give access once a month.

It is the enterprise edition. Do I need admin perissions on specific folders? I am sa on sql server already.

How do you get it to insert rather than update? I want to keep track of the changes in size weekly...

I'll try that thank you.