Dba: Create user that can have access all tables in Schema1 but just have insert to specific tabl...

Channel:
Peter Schneider
Subscribers:
4,140
Published on ● Video Link: https://www.youtube.com/watch?v=sUE-Cbi9WP8


Duration: 2:30
1 views
0

Create user that can have access all tables in Schema1 but just have insert to specific table in Schema2
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/5436/doodoo)DooDoo
(dba.stackexchange.com/users/220937/mbuschi)MBuschi
A special thanks goes out to the (https://dba.stackexchange.com/questions/334637/create-user-that-can-have-access-all-tables-in-schema1-but-just-have-insert-to-s)Stackexchange community

I wish you all a wonderful day! Stay safe :)

sql-server sql-server-2017



Other Videos By Peter Schneider


2024-01-10Replace characters in a string using conditional formatting R
2024-01-10Security: Do passkeys allow an attacker to gain account access by accessing a single device?
2024-01-10Merging DataFrame Columns in Python
2024-01-10Hardwarerecs: Difference, in graphic cards memory, between NIVIDA official page and laptop specif...
2024-01-10Security: Should my password contain part of the service's name?
2024-01-10Raspberrypi: How do I set up networking on Raspberry Pi OS - Bookworm
2024-01-10Assigning to uninitialized memory in C++
2024-01-10What is a "const class class_name&" in C++?
2024-01-10Tex: Does it make sense to typeset without inter-paragraph spacing?
2024-01-09Are C++ std::array iterators guaranteed to be pointer-like?
2024-01-09Dba: Create user that can have access all tables in Schema1 but just have insert to specific tabl...
2024-01-09Security: Why does the Public Key Info field in an X509 certificate for EC indicate the algorithm
2024-01-09Checking whether sets of columns are the same, row wise in R, in any order
2024-01-09Ethereum: How to put liquidity in uniswap liquidity pool using python-uniswap or web3?
2024-01-09Security: Issue uploading a file with cURL to WebSecurityAcademy Lab on PortSwigger.com
2024-01-09Networkengineering: Is there a limit to the number of 10G copper SFP modules one can use in a swi...
2024-01-09Retrocomputing: How were sprites handled on the IIgs?
2024-01-09How do I recover the password to a gmail account with hydra?
2024-01-09Apple: Running Typescript from Launchd
2024-01-09Ethereum: HD wallet sending ERC-20 tokens from two child addresses
2024-01-09Gis: GEE Error generating chart: Cannot read properties of null (reading 'init')


Tags:
sql-server
sql-server-2017