April 9, 2007 at 3:26 pm
Hi
I posted this in a different section earlier, I'm hoping to find someone with an answer since I belive it to be a security issue.
The problem is that several of us have gone into enterprise manager, selected a table, attempted to design and add a new column to said table and recieve this error when saving:
'tblBob' table
- Unable to modify table.
profile name is not valid
I believe we all have at least dbo permissions, some possibly admin. I also tried giving explicit permissions to this object but still no dice.
(I have not tried an alter table statement yet.)
Any help would be appreceated.
Thanks
April 9, 2007 at 4:41 pm
First: who owns the table? Look in Enterprise Manager, expand the database, click on Tables. Look down the list to find the table. Is the owner DBO or some other login?
Second: quote: I believe we all have at least dbo permissions, some possibly admin
You 'believe'??? Check and find out. That could be your problem right there.
-SQLBill
April 9, 2007 at 4:49 pm
Howdy
Table is dbo.tblbob
I should have said "we all have dbo permissions, i believe some even have admin."
I was hoping someone had seen this error before.
April 10, 2007 at 7:00 am
It's a database mail error.
"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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply