Showing posts with label non-admin. Show all posts
Showing posts with label non-admin. 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 :-)