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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to give owner rights to database

Author  Topic 

saranram_forum
Starting Member

9 Posts

Posted - 2009-05-11 : 08:56:31
Hi,
I need to know that how to give the owner rights to database in SQL server 2005 and how can we secure the database and how to enable Full-Text Indexing in my database.By default, I am having option to enable Full-Text Indexing but this is disabled.


Saravanakumar

NeilG
Aged Yak Warrior

530 Posts

Posted - 2009-05-11 : 09:07:41
If you are meaning giving db_owner rights to a user - in the user section in SSMS right click the user you require - select properties and then click to add the user to the db_owner group - You will need to either be the db_owner or sysadmin to grant these rights
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-05-11 : 22:30:18
Is Full-text service enabled in Config Manager?
Go to Top of Page
   

- Advertisement -