I have a user whose role is db_datareader that needs to be able to execute a stored procedure which decrypts some data using our symmetric key and certificate. I've granted EXECUTE perms on the stored procedure itself for this user, but now it wants access to the symmetric key and certificate. I'm not sure how to grant perms for the key and the certificate while still keeping this user in a SELECT or read-only mode. Is this possible?
Related Questions in SQL-SERVER-2008
- Why does the following script throw database still in use when selecting the master database first?
- Return Duplicate Rows
- SQL Data entry - finding sequence to enter info
- Why is this query in SSMS showing columns/tables as numbers?
- Query from multiple tables based on the table name?
- How to Let Python Connect to a SQL Server Database
- Need to fetch Minimum value for Each Id and make the BidSuccess column to 1
- Spring Boot Scheduled Annotation Job Issue
- Use different WHERE clause based on condition?
- Error when inserting special characters such as Ñ and accents á, é, í, ó, ú. using BULK OPENROWSET from python
- Delete all records except the max value of a group
- How to use SQL Server stored procedures in React js express server
- Loop through date in SQL Server and exclude the dates within a range of one week
- Find amount greater than the average amount
- Update trigger - both INSERTED and DELETE hold same value after update
Related Questions in PERMISSIONS
- How to request administrator rights?
- Private queues MSMQ lose Everyone permission
- Laravel spatie permission many to through? query
- Cannot access Google Spreadsheet metadata by API
- Why does each service need permissions to access something?
- How can I enable my app to access a specific partition directory for reading and writing without showing popup to user?
- Access denied when using Get-PnPSubWeb
- Running gcloud app deploy and getting PERMISSION_DENIED 'compute.regions.get', despite having Owner and Compute admin permissions
- iBooks folder permissions issue. I had access, now I don't have access. How can I regain access please?
- SolarIs 11 VM configure sftp. After restart ssh, the sshd_config file resets?
- Share folders and files between host and Docker as persistent data
- Provide access to Azure Storage Account for all VMs in resource group
- Grant auto permission dont work since Android 14
- ShouldShowRequestPermissionRational not working properly in Huawei HarmonyOS devices
- MAUI Email.ComposeAsync function call throws FeatureNotSupportedException on Android
Related Questions in CERTIFICATE
- Create aws certification for domain
- How can I create a simple signed certificate for my Windows Forms .NET app in Visual Studio 2022
- Problem validating server certificate connecting to a Kafka cluster
- connecting to secure server from Java application without importing certificate to keystore
- Inside Windows 2016 : error message : "Caused by: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty"
- Visual Studio 2022 free certificate problem. "cannot import key file " how to fix
- How do I sign a powershell script with in-network server so that all clients can run script without changing execution policy?
- Mac Sonoma 14.4 Dotnet 8.0.203 SDK webapi https error
- CA certificate for .NET Maui
- Fiddler doesn't work because Chrome and Edge don't trust fiddler certificate
- openssl: try to load local ca store
- Authentication with SmartCard sending a SOAPUI request
- SSL/TLS certificate exchange/renewal needs private key of the old certificate in CSR
- Questions about p12 certificate and private key password
- ERROR: Could not install packages due to an OSError: Could not find a suitable TLS CA certificate bundle, invalid path: /path/to/cacert.pem
Related Questions in SYMMETRIC-KEY
- Break Symmetric-Key Algo When Secret Key Is Known?
- Allow a stored procedure to decrypt an encrypted column
- How to create RSA SHA 256 SignatureEncryption and SymmetricKeyEncryption with ASP.NET VB.Net
- Paseto V3 Node.js - Local Secret Key must be 32 bytes long symmetric key Error
- Is it possible to encrypt a message outside of AWS KMS using a "key material" and decrypt using KMS?
- CryptoKit/Can not initialize SymmetricKey using SymmetricKey(data:)?
- How to import Symmetric key to thales HSM?
- Incorrect AES key length (89 bytes)
- Symmetric key creation with CKA_SENSITIVE false and CKA_PRIVATE as true
- How can I encrypt data with an already generated AES 256 GCM 96 key (coming from Hashicorp Vault)?
- Which KeyStore implementations can be used for storing symmetric keys?
- How can I Decrypt using libsodiumWrapper library using a public and a private key?
- Xcode 11 Swift 5 CryptoKit share SymmetricKey
- How do you protect your JWT Symmetric Security Key?
- Open chachapoly sealed box after removing and recreating a symmetric key (iOS)?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
In the header of your stored procedure use
WITH EXECUTE AS 'somePrincipal', wheresomePrincipalhas the necessary permissions to access the symmetric key and certificate.