I want to change the owner of the object.............
-
Hello friends! I want to change the owner of the object I have table whose owner is dbo but i want to change it to hov can u please tell me complete syntax of that Also when we right click on table and select design table , here we find menu like Trigger then Show permission then show dependency like that If I chose show permission here we find list all users/userdefined database roles/public like that , can u please explain that thing (window) to me what that mean by? T.I.A Shashank
-
Hello friends! I want to change the owner of the object I have table whose owner is dbo but i want to change it to hov can u please tell me complete syntax of that Also when we right click on table and select design table , here we find menu like Trigger then Show permission then show dependency like that If I chose show permission here we find list all users/userdefined database roles/public like that , can u please explain that thing (window) to me what that mean by? T.I.A Shashank
What are you talking about ? I got to Design Table in SQL Server, then I could not follow your instructions - are you using SQL Server, or something else ? Not that you need to use SQL Server, but you could provide at least some clue, seeing as your question is not about SQL, ADO, or ADO.NET. Christian Graus - Microsoft MVP - C++
-
What are you talking about ? I got to Design Table in SQL Server, then I could not follow your instructions - are you using SQL Server, or something else ? Not that you need to use SQL Server, but you could provide at least some clue, seeing as your question is not about SQL, ADO, or ADO.NET. Christian Graus - Microsoft MVP - C++
under2811Hi I am asking two thing first is how to change owner of a table i.e. I have table whose owner is 'dbo' and now I want to change owner dbo to owner 'hov' How to change that??? second thing i asked if we open E.M here we find lots of table suppose if I right click on one table say employees then we get menus like new table,design table,open table like that if i cliked on design table , we find another more menus like set primary keys,triggers,show permissions like that now i want to know what this term 'show permission' is??? please explain in detail shashank
-
under2811Hi I am asking two thing first is how to change owner of a table i.e. I have table whose owner is 'dbo' and now I want to change owner dbo to owner 'hov' How to change that??? second thing i asked if we open E.M here we find lots of table suppose if I right click on one table say employees then we get menus like new table,design table,open table like that if i cliked on design table , we find another more menus like set primary keys,triggers,show permissions like that now i want to know what this term 'show permission' is??? please explain in detail shashank
Ah, I see. It shows the users of the database, and what permissions each of them has in regard to that table. Or, if you don't know what it is, don't mess with it :-) The answer to question 1 is probably sp_changeobjectowner. Look it up in the SQL Server books that come with the product. Christian Graus - Microsoft MVP - C++
-
Hello friends! I want to change the owner of the object I have table whose owner is dbo but i want to change it to hov can u please tell me complete syntax of that Also when we right click on table and select design table , here we find menu like Trigger then Show permission then show dependency like that If I chose show permission here we find list all users/userdefined database roles/public like that , can u please explain that thing (window) to me what that mean by? T.I.A Shashank
I don't know how to do it from enterprize manager, but you can run sp_changeobjectowner from query analyzer to change the ownership of a table.