SQLServerCentral Article

PostgreSQL Triggers Part 2

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and how to create a trigger with basic syntax and examples. If you haven't read it […]

Stairway to SQL Server Security

Stairway to SQL Server Security Level 5: Schemas and Security

In this stairway level you’ll learn how you can give principals access to groups of objects by assigning permissions on schemas instead of individual tables, code modules, and other objects. You’ll also learn about the benefits of user-schema separation and how it can increase object security, and how using default schemas for users and groups can simplify object access management and security.

Blogs

Daily Coping 26 Sep 2022

By

Today’s coping tip is to enjoy photos from a time with happy memories. On...

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Read the latest Blogs

Forums

Seggregating access within a database to users

By noobdba

For some folks that have gotten used to working in Oracle where a user...

Replication Error on identity Column : Transactional Replication

By Tom257

  I have manually deleted data from a subscriber replicated table, and broken replication....

Two fact tables related

By Maria

Hi all, I have a couple of modelling questions using several star schemas. There...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Using R apply

See possible answers