I am trying to delete a principal from the database but can't because it owns a schema. When I go to edit the user, however, the box to uncheck schema is blue and unremovable. How can I …

(SQL-Server) What tool do you use? Documentation Storage Format for database schema/meta-data? Word documents Excel spreadsheet Plain Text Documentation process or policies? I …

SELECT * FROM fn_my_permissions('Database.Schema.Table', 'OBJECT'); REVERT; If the user is tied to an AD user or group, consider running repadmin /syncall to force any changes made …

The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. ...since creating a user in a database doesn't give them automatic rights to anything in that …

The basic concept is to use GRANT/DENY Schema Permissions. You can efficiently manage permissions by creating a role and then adding members to it. Below is an example that will …

Error: The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'. The Login has membership only in the …

5 Our developers have a domain account used by their application that needs to be able to execute stored procedures created in the master database using the "sp_" naming convention …

If you need something fairly quick and dirty to compare schemas, I wrote this gist to help compare a running schema to a "latest" schema -- something maybe hosted in SCM. It's working fairly …

Whenever I create a brand new database in PostgreSQL Maestro it creates the following list of default schemas: Now from my understanding Schemas are like folders for organization, etc. …

I'm using MySQL. The idea is similar to shopify with a different concept, so users are going to add their own products with multiple types of variants and attributes. From all the research I've done