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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2009-03-13 : 17:42:52
|
| Hi,There are two tables Stag1 and orig .There is a process which will rename the orig table to stag1 and stag1 to orig .I have a role which has permissions to the Orig table .When the above process runs does it change the permissions to the Stag1 table ? |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-03-13 : 19:12:21
|
| Hello;I don't believe renaming a table changes its permissions. The permissions that were in place before the rename would remain unchanged. r&r |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-03-16 : 10:14:14
|
| I tested this ,it is changing the permission too and process is failing .Its better to give permissions to both. |
|
|
|
|
|
|
Renaming