SQL Schema and SQL Tables

SQL Schema is 'dbo' as default. You may add new tables but whenever you add a new table a schema is added to your table. Specific users may grant permissions to schemas different than default 'dbo' schema.

In order to GRANT schema permissions:

After running this script with an admin user, User1 can add new tables with developer_schema.PS:If you do not have the permission, you will get the error below:
The specified schema name "..." either does not exist or you do not have permission to use it.

No comments:

Post a Comment