Skip navigation
Menu
Data Analytics and Data Management>SQL

Where does SQL server store the permissions on tables?

A. For SQL 6.5 and below this is held in <dbname>..sysprotects. 

For 7.0 and above <dbname>..syspermissions.

TAGS: SQL
Hide comments

More information about text formats

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish
Recommended Reading
digital world map on warehouse background
How To Build an International Shipping Software System
Jan 30, 2024
PowerShell Analytics header.jpg
Interactive Data Analytics With PowerShell, SQL, and ChatGPT (Sample Script)
Sep 19, 2023
blue gears
How To Filter SQL Server Data in Windows PowerShell
Sep 15, 2023
PowerShell Chart hero.jpg
How To Visualize SQL Server Data in PowerShell (With Sample Script)
Sep 11, 2023