April 28, 2010 at 3:30 am
Hi
i have a database which has many jobs running on it under a proxy agent. When the proxy creates a table the default schema is dbo. However when a job fails on the server, the support team runs the job manually under their ids.
The problem is when a analyst creates table it gets created as username.tablename. i want this to be restricted. when the analyst creates table, i want it to be dbo.tablename.
how do i do that.
elementary but I am sort off struggling with this
April 28, 2010 at 4:58 am
anyone?
April 28, 2010 at 5:59 am
ALTER USER UserName
WITH DEFAULT_SCHEMA = 'dbo'
I think that ought to do it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply