Viewing Full text schedule
-
Hi,
Is it possibele to grant rights to view Fulltext schedule without giving the user dbo rights. One of the user who created FT index wanted to view the schedule. But company policy does not allow us to grant dbo rights on any production box. My question is
1. What best I can do in this scenerio?
2. How do I give justification for this?
3. Does assinging the user to any role helps??
Please help.
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me -
Just tell them what the schedule is, if they're not happy with that then tough, you could do a screengrab if they preferred
Sorry, it's been a long morning and i'm not in the mood for 'user' requests.
-
Helen
As the SQL 2000 BOL title "sp_fulltext_catalog" states that "Only members of the sysadmin fixed server role and the db_owner (or higher) fixed database roles can execute sp_fulltext_catalog", you're somewhat limited. However, you can your user with a TSQL script that is generated by the SQLServerAgent job. In the Enterprise Manager, open the Managment forlder & SQL Server Agent folder and right-click on the Fulltext schedule job. Then select "All Tasks" and click on "Generate SQL script..." and save the sql code to a file. You should be able to give the user this code to satasify him and as he will not have DBO rights, he cannot execute it on your production server.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
John T. Kane -
Hi,
I gave him something like this, again had to grant him public rights on sysjobs and syschedules on msdb
Use Msdb
go
select 'Start_Full on upside' as Job_Name, name as schedule_Name,
case freq_type
when 1 then ' Once'
when 4 then ' Daily'
when 8 then ' every Week '
+ case freq_interval & 2 when 2 then 'Monday, ' else '' end
+ case freq_interval & 4 when 4 then 'Tuesday , ' else '' end
+ case freq_interval & 8 when 8 then 'Wednesday, ' else '' end
+ case freq_interval & 16 when 16 then 'Thursday ,' else '' end
+ case freq_interval & 32 when 32 then 'Friday ' else '' end
+ case freq_interval & 64 when 64 then 'Saturday ' else '' end
+ case freq_interval & 1 when 1 then 'Sunday' else '' end
when 16 then 'Mthly one day ' + convert(varchar(2), freq_interval) end as Schedules,
substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6),active_start_time), 6), 1, 2)
+ ':'
+ substring (
right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_start_time), 6) ,3 ,2)
+ ':'
+ substring (
right (stuff (' ', 1, 1, '000000') + convert(varchar(6),active_start_time), 6) ,5 ,2) as start_at
,case freq_subday_type
when 1 then NULL -- Ignore the end time if not a recurring job
else substring (right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_end_time), 6), 1, 2)
+ ':'
+ substring (
right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_end_time), 6) ,3 ,2)
+ ':'
+ substring (
right (stuff (' ', 1, 1, '000000') + convert(varchar(6), active_end_time), 6) ,5 ,2) end as end_at
from sysjobschedules where job_id =
(select job_id from sysjobs where name ='Job_name')
go
Hope this will be useful to someone
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply