How do I create “groups of users” and set permissions in SQL Server?

I am new to SQL Server, and I need to do something like the following:

  • Create a group of users that will allow them to only SELECT from Table 1, but be able to SELECT, UPDATE, DELETE and INSERT INTO Tables 2 and 3;
  • Create another group of users that will allow them to SELECT, UPDATE, DELETE and INSERT INTO all three of the aforementioned tables

All three of the tables are in the same database.

May someone please provide some sample code so that I can accomplish something like that? Thanks!

Automorphism groups of field extensions

Let $F_1$ be a field and $F_2$ its prime subfield. Consider the automorphism group $Aut(F_1/F_2)$. How does one show that this is equivalent to the automorphism group of $Aut(F_1)$? I know that any automorphism $psi$ of $F_1$ is the identity map on $F_2$ since it is a prime subfield thus generated by $1_{F_1}$. How would we show $Aut(F_1/F_2)=Aut(F_1)$?

How to get the user’s group(s) for sharepoint online site usig Microsoft Graph APIs

I am trying to get the user’s group(s) for Sharepoint online site using Microsoft Graph APIs. But I am not getting any equivalent graph API for the below Sharepoint rest API :

/_api/web/SiteUsers/GetByEmail(‘xxxxx@xxxxx.com’)?$expand=Groups

I want the sharepoint groups not the AD groups. Thanks in advance.

ag.algebraic geometry – density of unipotent flows in algebraic groups

Let $mathcal{G}$ be a reductive algebraic group over $mathbb{Q}$ with a model $G$ over $mathbb{Z}$ such that $G(mathbb{R})$ is compact modulo centre. Let $T$ be a maximal torus of $mathcal{G}$. My question is: whether there exist a prime $p$ and a (non-trivial) homomorphism of $p$-adic groups $phi_pcolonmathbb{Q}_prightarrow G(mathbb{Q}_p)$ such that the image $mathrm{Im}(phi_p)$ is normalized by the maximal torus $T(mathbb{Q}_p)$ and the product set $G(mathbb{Z}(frac{1}{p}))mathrm{Im}(phi_p)$ is dense in $G(mathbb{Q}_p)$?

We know that $mathrm{Im}(phi_p)$ is contained in a unipotent subgroup of $G(mathbb{Q}_p)$, thus ‘unipotent flow’ in the title. For the case $G=B^times$ for some definite quaternion algebra $B$ of centre $mathbb{Q}$, this answer is (trivially) affirmative. If we drop the condition that $mathrm{Im}(phi_p)$ being normalized by $T(mathbb{Q}_p)$, this is also affirmative(using Hedlund’s lemma, for example). I am wondering if there are any results related to the above question for general $G$. I feel that we need to put some condition such as ‘simply-connected’ on $G$, but I do not know how to prove it in this case.

sharepoint foundation – Cant find azureAD Groups in SP2013

We got AzureAD authentication working on our On premise SP2013 environment using this tutorial: https://docs.microsoft.com/nl-nl/azure/active-directory/saas-apps/sharepoint-on-premises-tutorial

We are able to find AzureAD users inside SharePoint 2013, but we cant find the security Groups We created in AzureAD. We Also used The GUID of the security group in people picker, but still no results

Any idea what the problem could be?

Thx for the support 🙏!

availability groups – Join duplicating the data – SQL Server

I am working with SQL Server Always On and I am querying the data as follows:

SELECT
name as AGname,
replica_server_name,
CASE WHEN  (primary_replica  = replica_server_name) THEN  1
ELSE  '0' END AS IsPrimaryServer
FROM master.sys.availability_groups Groups
INNER JOIN master.sys.availability_replicas Replicas ON Groups.group_id = Replicas.group_id
INNER JOIN master.sys.dm_hadr_availability_group_states States ON Groups.group_id = States.group_id
ORDER BY name

This gives me the output I need, however, I also need the DB name so I am trying the following:

SELECT
name as AGname,
DB_NAME(AG_DB.database_id) AS DatabaseName,
replica_server_name,
CASE WHEN  (primary_replica  = replica_server_name) THEN  1
ELSE  '0' END AS IsPrimaryServer
FROM master.sys.availability_groups Groups
INNER JOIN master.sys.availability_replicas Replicas ON Groups.group_id = Replicas.group_id
INNER JOIN master.sys.dm_hadr_availability_group_states States ON Groups.group_id = States.group_id
INNER JOIN master.sys.dm_hadr_database_replica_states AG_DB ON AG_DB.group_id = Groups.group_id
ORDER BY name

However, this is giving me issues as it is duplicating the information.

I also tried to fix this issue by doing the following:

SELECT
name as AGname,
(SELECT DISTINCT DB_NAME(AG_DB.database_id) FROM master.sys.dm_hadr_database_replica_states AG_DB WHERE AG_DB.group_id = Groups.group_id) AS DatabaseName,
replica_server_name,
CASE WHEN  (primary_replica  = replica_server_name) THEN  1
ELSE  '0' END AS IsPrimaryServer
FROM master.sys.availability_groups Groups
INNER JOIN master.sys.availability_replicas Replicas ON Groups.group_id = Replicas.group_id
INNER JOIN master.sys.dm_hadr_availability_group_states States ON Groups.group_id = States.group_id
ORDER BY name

The latter is giving me “Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression” error.

Any suggestions how I can get the required output without the duplicate entries?

I will promote your products or link in real USA for $5

I will promote your products or link in real USA

About This Gig

Welcome to my Facebook Marketing and Promotion Sirvice !

Hello, I’m a digital marketer specializing in social media marketing. I have completed a professional course in Digital Marketing from the Digital Outsourcing Institute of Bangladesh. I can promote your business, product or link in large active facebook groups in the USA. I have access to those groups of the USA which are used for buying, selling and trading. I have a good understanding of marketing language and customer psychology. I will help you promot or reach a large audience and boost your sales.

My Specialties:

Posting in Large 15 Groups with Real Active Members of USA country

Use Attractive Product Descriptions and eye catching Images

100 % Manual Posting on this grups

Spam Free Posts

Proof Submit of Work in Google Sheets

On-Time Delivery

What You Get:

Audience Reach Up To A large of Real Active Users

Rapid Audience Engagement and Growth

Real Customers

More Likes and Followings

More Profit and More Sales

.

permissions – Efficient way to get rights of users based on the groups they are in

We do not assign rights directly to a user but assign users to groups and groups have rights(or permissions) attached to them.

There are about 15 permission types and so there can be a lot of groups that a user is in with different permissions on different resources(which are called sites in the system).

What is the best way to get user permissions quickly based on all the groups they are in. What’s the best way to calculate it efficiently?

We are using DynamoDB** if that matters.