March 16, 2009 at 8:58 am
how do i change the schema of a table.
If i modify a table and then change the schema name, it prompts me
"changing the schema of this object will result in all current permissions on this object being dropped."
What will be the impact of choosing yes for the above?
Thanks for your reply...
March 16, 2009 at 9:15 am
What would happen is that if there are any users or roles in your DB that has Select update insert and delete permission on this table, you will have to recreate it.
Also one more thing you have to keep in mind, Let us say that the First Schema was DBO and you change it to abc, then the stored procs that does selects updates ect that references this object as dbo.tablename will also fail since there is no object like that under the Schema DBO.
-Roy
March 16, 2009 at 10:14 am
so what i have to do is simply to check the permissions for theobject before deleting changing the schema.
Perhaps i can find out the script on the various permissions necessary for reaplying it?
if so dow we have script to fnd out the relevant script for an object so that once i change the schema object i can re-execute the script and keep it in sync.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply