Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2008-05-20 : 02:57:13
|
| HiWhat permissions do I need to set so that a user can change tables, views and procedures? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-20 : 03:25:49
|
DDL-admin.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-05-20 : 04:19:16
|
| He is already that, but still cannot change a table... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-20 : 04:30:49
|
Does he belong to the owners for the table?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-05-20 : 04:51:32
|
| Where do I check that? |
|
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2008-05-20 : 05:45:24
|
| The owner of the database is sa... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-20 : 09:47:06
|
| "What permissions do I need to set so that a user can change tables, views and procedures?"you mean changing structure DDL or DML? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 22:25:31
|
| Add user to schema that objects belong to. |
|
|
|
|
|
|
permissions to change table, views and procedures