Alter Table that is not yours

[kim1]

Hi,

Can I set some permission to be able to Alter Table that is not mine.

Ex. My account is called AcctA (with only ddladmin and securityadmin database role).

AcctB create a table A, and I (AcctA) want to alter it.

Can I, even if I am not the owner of the table A?

Kim Kim

 

[chiph]

Only if AcctB gives you permission to.

Chip H.

 

[kim1]

How can AcctB set the permission so the AcctA can alter table? Thank you for your help Chip.H.
Kim

 

[chiph]

AcctB runs this SQL:

GRANT ALTER TABLE ON tableA TO AcctA

But according to the chart in Books Online, the db_ddladmin role already has the Alter Table privledge.

BTW, AcctB will have rights to run the GRANT statement because they are the owner of the object. It can also be run by users with the db_securityadmin role.

Chip H.