SQL SCRIPT to grant DBC_Execute to all user defined Stored Procs.This SQL SCRIPT is handy specially after Stored Procs are DROPPED & CREATED; often users dont mention the SQL to grant DBC_Execute permission to the Store Procs.This SQL SCRIPT will grant execute permission to DBC_Execute for all user defined Stored Procs. The SCRIPT can be […]
2004-10-03
175 reads
The SQL 7.0 Query for listing of all users tables with owner, no of rows and Date/Time created is as follows
2002-06-06
287 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Hello, so I was reading on partitioning a large table, Which i successfully did,...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
Ask SSC