Wednesday, March 7, 2012

changing owner of stored procedure

Is there a way to change the owner of a stored procedure?
I used Enterprise Manager to create a stored procedure. But since it was
created under my login name, other users are denied permission. Rather than
explicitly giving permission to everyone, I would like to change the owner
to 'dbo'.
How?
Lisasp_changeobjectowner
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:ubuJHdw7DHA.2924@.tk2msftngp13.phx.gbl...
> Is there a way to change the owner of a stored procedure?
> I used Enterprise Manager to create a stored procedure. But since it was
> created under my login name, other users are denied permission. Rather
than
> explicitly giving permission to everyone, I would like to change the owner
> to 'dbo'.
> How?
> Lisa
>

No comments:

Post a Comment