Technical Article

Grant EXECUTE permission to users

This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]

You rated this post out of 5. Change rating

2005-05-05 (first published: )

214 reads

Blogs

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs

Forums

Small Transactional Table with Frequent Updates

By WoundedParrot

Hi All We have a 12 row on our platform that gets updated for...

Sporadic error during restore job

By webrunner

Hello experts, I see this error in a SQL Agent job. It happens during...

Average price calculation

By Puiu

Hello! I need to make a query that will calculate my average price for...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers