Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    16

    Unanswered: sql permissions question

    Hi,

    I need someone to be able to create procedures and create jobs on our sql servers. What is the lowest level of access I should give them? I don't want to give sa access....

    Thanks,
    Meera

  2. #2
    Join Date
    Sep 2003
    Posts
    66
    The following sql code showing grant 'select','insert','update','delete' to user 'usr' to table 'codeq':
    REVOKE ALL PRIVILEGES ON `codeq` . * FROM "usr"@ "localhost";

    REVOKE GRANT OPTION ON `codeq` . * FROM "usr"@ "localhost";

    GRANT SELECT ,
    INSERT ,

    UPDATE ,
    DELETE ON `codeq` . * TO "usr"@ "localhost";
    hopes help.

  3. #3
    Join Date
    Sep 2003
    Posts
    16
    Hi ,

    Well I don't want to grant permissions on a particular object. I want the user to be able to :
    1) create stored procedures
    2) create jobs .

    Thanks,
    Meera

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    You have only to grant permission for creating stored procedures:

    grant CREATE PROCEDURE to youruser

    sp_add_job, etc. - execute permissions default to the public role (you do not need to grant any permissions).

    Of course it needs to give to youruser some permissions on db objects.

  5. #5
    Join Date
    Sep 2003
    Posts
    522
    grant permission to users for objercts that are accessed by the job? I don't think so. the job is executed in the security context of sqlagent account, not user account.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •