Example permissions

Example permissions showing how another party can use your dataset.

Examples are shown for all combinations of permission settings. For a description of each permission setting, see the permissions overview.

View meta-data and assess the intersection with other datasets - In combination with datasets they own

Sent permissions

Example 1

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset.

SELECT 
 COUNT()

FROM ACME INTERSECT Autosports

Output:

As shown, an error is returned because the other party is not permitted to query your ACME dataset. The other party can only view statistics for the connection between ACME and AutoSports (but not datasets the other party has permissions to use) in the Connection List, as shown below.

Example 2

The example query below shows what the other party can see with this permission if ACME is your dataset and Autosports is the other party’s dataset.

SELECT 
 COUNT()

FROM ACME
WHERE ACME.Age > 20

Output:

As shown, an error is returned because the other party does not have permission to query your ACME dataset. The other party can only view statistics for the connection between ACME and AutoSports (but not KnowArc) in the Connection List, as shown below.

View meta-data and assess the intersection with other datasets - In combination with datasets they own or have permission to use

Sent permissions

Example 1

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset.

SELECT 
 COUNT()

FROM ACME INTERSECT Autosports

Output:

As shown, an error is returned because the other party is not permitted to query your ACME dataset. The other party can only view statistics for the connection between ACME, AutoSports and any datasets the other party has permissions to use (for example, KnowArc) in the Connection List, as shown below.

Example 2

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset. KnowArc is the dataset that other people have given them permissions to use.

SELECT 
 COUNT()

FROM ACME INTERSECT AutoSports INTERSECT KnowArc
WHERE KnowArc.shopaholic = 'Yes'

Output:

As shown, an error is returned because the other party can query AutoSports and KnowArc, but not your ACME dataset. The other party can only view statistics for the connection between ACME, AutoSports and KnowArc in the Connection List, as shown below.

Query the intersection with other datasets - In combination with datasets they own

Sent permissions

Example 1

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset.

SELECT 
COUNT()

FROM ACME INTERSECT AutoSports
WHERE ACME.Age > 20

Output:

As shown, the other party can query the intersection of their AutoSports dataset with your ACME dataset. The other party can also view statistics for the connection between ACME and AutoSports (but not datasets the other party has permissions to use (for example, KnowArc) in the Connection List, as shown below.

Example 2

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset. KnowArc is the dataset that other people have given the other party permissions to use.

SELECT 
 COUNT()

FROM ACME INTERSECT AutoSports INTERSECT KnowArc
WHERE KnowArc.shopaholic = 'Yes'

Output:

As shown, an error is returned because the other party is not permitted to query your ACME dataset with KnowArc, a dataset they have permission to use. The other party can only view statistics for the connection between ACME and AutoSports (but not KnowArc) in the Connection List, as shown below.

Query the intersection with other datasets - In combination with datasets they own or have permission to use

Sent permissions:

Example 1

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset.

SELECT 
 COUNT()

FROM ACME INTERSECT AutoSports
WHERE ACME.Age > 20

Output:

As shown, the other party can query the intersection of their AutoSports dataset with your ACME dataset. They can also view statistics for the connection between ACME, AutoSports and any datasets the other party has been given them permission to use in the Connection List, as shown below.

Example 2

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset. KnowArc is the dataset that other people have given the other party permissions to use.

SELECT 
 COUNT()

FROM ACME INTERSECT AutoSports INTERSECT KnowArc
WHERE KnowArc.shopaholic = 'Yes'

Output:

As shown, the other party can query the intersection of their AutoSports dataset with your ACME dataset and the KnowArc dataset, which they have permission to use. They can also view statistics for the connection between ACME, AutoSports and KnowArc in the Connection List, as shown below.

Query the whole dataset - In combination with datasets they own

Sent permissions

Example 1

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset.

SELECT 
COUNT()

FROM ACME 
WHERE ACME.Age > 20

Output:

 

As shown, the other party can query the whole of your ACME dataset. They can also view statistics for the connection between ACME and AutoSports (but not datasets the other party has permissions to use) in the Connection List, as shown below.

Example 2

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset. KnowArc is the dataset that other people have given the other party permissions to use.

SELECT 
 COUNT()

FROM ACME INTERSECT AutoSports INTERSECT KnowArc

WHERE KnowArc.shopaholic = 'Yes'

Output:

As shown, an error is returned because the other party is not permitted to query your ACME dataset with KnowArc, a dataset they have permission to use. The other party can only view statistics for the connection between ACME and AutoSports (but not KnowArc) in the Connection List, as shown below.

Query the whole dataset - In combination with datasets they own or have permission to use.

Sent permissions:

Example 1

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset.

SELECT 
 COUNT()

FROM ACME 
WHERE ACME.Age > 20

Output:

As shown, the other party can query the whole of your ACME dataset. They can also view statistics for the connection between ACME and their datasets (including any datasets the other party have been permission to use) in the Connection List, as shown below.

Example 2

The example query below shows what the other party can see with this permission if ACME is your dataset and AutoSports is the other party’s dataset. KnowArc is the datasets that other people have given them permissions to use.

SELECT 
 COUNT()

FROM ACME INTERSECT AutoSports INTERSECT KnowArc
WHERE KnowArc.shopaholic = 'Yes'

Output:

As shown, the other party can query the intersection of their AutoSports dataset with your ACME dataset and the KnowArc dataset, which they have permission to use. They can also view statistics for the connection between ACME, AutoSports and any datasets the other party has been given them permission to use (for example, KnowArc) in the Connection List, as shown below.