Allow Minimal Execution of PowerShell Commands

This topic contains 4 replies, has 3 voices, and was last updated by  Ajay Dwivedi 3 months ago.

  • Author
    Posts
  • #94003

    Ajay Dwivedi
    Participant

    Hi Experts,

    I am SQL DBA in current role. I have created few PowerShell commands as part of a module named SQLDBATools to carry out some basic tasks against SQL Server. Now, I wish to grant execute permission for few of those commands for another AD group like 'IT-Network-Teams'.

    Kindly suggest me any blog post/article/method to carry out the task.

    Regards,
    Ajay Dwivedi
    http://ajaydwivedi.com

  • #94015

    Don Jones
    Keymaster

    There's no such thing as "execute permissions" for a PowerShell command; PowerShell itself is not a security layer. Provided the people have permission to do whatever it is the command is doing, then they can execute them.

    Security is not something you do on a per-command basis in Windows.

  • #94057

    Christian Sandfeld
    Participant

    You could look into JEA (Just Enough Administration) to allow only a subset of commands to be run:

    • #94080

      Ajay Dwivedi
      Participant

      Thanks Christian. I think this is what I was looking for.

You must be logged in to reply to this topic.