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)  Limited Rights to only Job Sql

Author  Topic  iguypouf Starting Member 1 Post Posted - 2009-10-08 : 05:53:09 Hi all, After a small search accross the net I don't find solution to my problem. I've seen that an aspx application that I manage was using the dbowner account to connect sql I'm going now change that to create a new sql account to restrict access to only needed tables... But this application must launch a job sql from the SQL Server Agent, and this job must launch a C#.exe application on the server (file managing). So : - this job must have an owner which is a Windows account (and not my new account) to be able to launch the application - this job so isn't reachable by my application, except if I add the System Administrator Role to my new user. - but if I add the System Administrator Role to this account, this role overrides the permissions managed through the permissions feature. How can I have an user account like this : - limited rights : only "public" role on database, with permissions object by objet - able to launch a sql job with a different owner My Configuration : SQL Server Standard Edition Version 8.00.2039 (SP4) Best Kind Regards and thanks for help !