## 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?

## 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.

## lie groups – Root system : Constructing the Dynkin diagram

this is the image of the root system of $$A_2$$ i found online can someone explain to me how we construct the Dynkin diagram from this and why it’s different from $$D_2$$

Also, why the root systems are represented like that what is the geometric meaning?

## packages – CharacterTable for symmetric groups \$S_n\$ with large \$n\$

I am looking for a package to generate character tables for symmetric groups $$S_n$$. At this moment I am using

``````FiniteGroupData[{"SymmetricGroup", n}, "CharacterTable"]
``````

but it works only for $$nleq 10$$. Does there exist a package which can be used to get similar results for larger values of $$n$$?