I have a stored procedure which picks data from a particular column from a table and execute that data, which means the data will itself be a query, most probably some update or delete or insert statements.
Now the problem is, there is a high risk of the tables getting altered or dropped because this data can be any statements which the user inserts(of course there are approval scenarios and status checks and all ,but still..) .
And there is a restriction of using the user login(which have ddl permission) for the web app, so I cannot restrict based on login.
Is there any way so that this particular session which executes the statement can be restricted from any ddl permissions?
Can I restrict any session from altering or dropping tables
25 Views Asked by AKSHAY R At
0
There are 0 best solutions below
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in DYNAMIC-QUERIES
- Insert latest 3 records from a huge table(40 million records) which has data from different years
- How to find multiple and dynamic values using JPA and Specifications with spring boot
- PLPGSQL Dynamic Query - ERROR:PL/pgSQL function inline_code_block lin
- UCAExc:::3.0.7 user lacks privilege or object not found, when trying to execute specifically update/delete/append queries
- Dependant Tanstack useQueries. How to chain them?
- How to strip UTM tags in Varnish without stripping queries I want?
- Attempting to optimize a excel query by converting it to an ADODB connection
- Perform simple queries in Cloud Firestore - how can i filter all through select?
- Can I restrict any session from altering or dropping tables
- Can results of a dynamic query feed into a CTE?
- How can I turn this dynamic query into a procedure or function?
- Incorrect datetime value error - MYSQL dynamic query
- How Can I Iterate over each element in JSON array and join with rows in SQL SERVER
- Criteria API find Key-Value Pairs in Map
- Dynamic query in azure data factory based on array variable
Related Questions in SQL-SESSIONS
- Can I restrict any session from altering or dropping tables
- MyBatis PersistenceException SQLRecoverableException: IO Error: Connection closed, Authentication lapse 0 ms
- accessing master page session in child pages
- The system hang while calling sqlSesssion.flushStatement()
- ### Error getting a new connection. Cause: java.sql.SQLException: I/O Error: Socket closed
- How to use SQL session-based tables with Entity Framework 5
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)
Popular # Hahtags
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?