What permissions must I grant to allow a user to rename a table?
I have my stored procedure rename a table when it is done, but it fails and
says the user does not have permission.
ThanksI figured it out
I had to add the user as a user in the MASTER db and then grant exec on
sp_rename to the user
Thanks
"Tarren" <noemailplease@.thanks.com> wrote in message
news:%23zYU59NXFHA.1468@.tk2msftngp13.phx.gbl...
> What permissions must I grant to allow a user to rename a table?
> I have my stored procedure rename a table when it is done, but it fails
> and says the user does not have permission.
> Thanks
>|||You have an SP that renames a table in the MASTER database?
"Tarren" <noemailplease@.thanks.com> wrote in message
news:%23zYU59NXFHA.1468@.tk2msftngp13.phx.gbl...
> What permissions must I grant to allow a user to rename a table?
> I have my stored procedure rename a table when it is done, but it fails
and
> says the user does not have permission.
> Thanks
>|||I'm curious as to why you would want to rename a table in an SP.
David Portas
SQL Server MVP
--|||the SP is a procedure in my ETL process that loads from all of the incoming
tables into a master_staging table and then cleans the data with a number of
individual updates
then, after the several minute process completes, it swaps the current
master table with the master_staging table using three sp_rename statements
This lets me load the fresh data from the incoming tables every night and
provide 24x7 uptime on the master table (not having it be out of commission
for several minutes a day) since all of the inserting and updating never
take place in the live master table.
:)
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1116593359.212844.263680@.o13g2000cwo.googlegroups.com...
> I'm curious as to why you would want to rename a table in an SP.
> --
> David Portas
> SQL Server MVP
> --
>|||the procedure to rename an object in SQL Server 2000 is located in the
Master DB with all of the other SQL Server sp's
"JT" <someone@.microsoft.com> wrote in message
news:u9$SJnTXFHA.3140@.TK2MSFTNGP14.phx.gbl...
> You have an SP that renames a table in the MASTER database?
> "Tarren" <noemailplease@.thanks.com> wrote in message
> news:%23zYU59NXFHA.1468@.tk2msftngp13.phx.gbl...
> and
>|||If that is the case, then why not simply add a date field to your staging ta
bles
that stores the date they were populated and periodically delete rows based
on
this date?
Thomas
"Tarren" <noemailplease@.thanks.com> wrote in message
news:OOLBq1yXFHA.3712@.TK2MSFTNGP09.phx.gbl...
> the SP is a procedure in my ETL process that loads from all of the incomin
g
> tables into a master_staging table and then cleans the data with a number
of
> individual updates
> then, after the several minute process completes, it swaps the current mas
ter
> table with the master_staging table using three sp_rename statements
> This lets me load the fresh data from the incoming tables every night and
> provide 24x7 uptime on the master table (not having it be out of commissio
n
> for several minutes a day) since all of the inserting and updating never t
ake
> place in the live master table.
> :)
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1116593359.212844.263680@.o13g2000cwo.googlegroups.com...
>
