Skip to content

Schelstraete.org

  • Home
  • Home
1505, 2019

T-SQL: Give views permissions to all stored procedures

Bschelst/ May 15, 2019/ Uncategorized/ 0 comments

You can use the T-SQL code below within your database to give permissions to ‘MYUSER’ for viewing all stored procedures. (of course, replace “MYUSER” with your own user) Once executed, you can copy and paste the output to a new query window an execute it.

Search for:

Recent Posts

  • T-SQL: Kill all inactive sessions from specific user
  • T-SQL: Check status of automatic seeding
  • T-SQL: size of replication specific tables
  • T-SQL: check replication backlog
  • T-SQL: Resume or suspend all always on databases

Archives

  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • Uncategorized
Schelstraete.org