Showing posts with label owner. Show all posts
Showing posts with label owner. Show all posts

Friday, March 23, 2012

How to allow FULLTEXT SEARCH INDEXING to non-admin user?

I've tried searching alot on the net but am not able to find how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates.
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help

Cheers
LuckyHelllooooo.....does anyone know abt it?sql

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

Wednesday, March 21, 2012

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

Wednesday, March 7, 2012

How to add an existing user to a database as the owner

Is there a way to add an existing user as an "owner" of a database programmatically using SQL or a SP?
Thanks.Is there a way to add an existing user as an "owner" of a database programmatically using SQL or a SP?

Thanks.

exec sp_addrolemember N'db_owner', N'User_Name'

Replace User_name with actual user name

hope this helps.|||In addition, if that user currently, belongs to another role, you might want to drop the user from that role using sp_droprolemember|||It's actually sp_changedbowner that needs to be used if you want to change the ownership of a database.|||thanks that worked like a charm :)