Hi
I have an User account that has db_ddladmin database role permission. I did Grant access to table, view and stored procedure of msdb database to this user, but still not be able to view the jobs in Enterprise Manager the list of Jobs in Jobs folder.
I can view the jobs in SQL Analyzer but NOT in Enterprise Manager. Is there any way to let this user to view all the job without assigning this user account db_owner permission?
Thank you for your help
Kim
I have an User account that has db_ddladmin database role permission. I did Grant access to table, view and stored procedure of msdb database to this user, but still not be able to view the jobs in Enterprise Manager the list of Jobs in Jobs folder.
I can view the jobs in SQL Analyzer but NOT in Enterprise Manager. Is there any way to let this user to view all the job without assigning this user account db_owner permission?
Thank you for your help
Kim