SQLML: sqlmlutils is per db/user

garyericson · garyericson · commit 49e4ea235f06 · 2020-08-26T17:13:48.000-07:00
diff --git a/docs/machine-learning/package-management/install-additional-python-packages-on-sql-server.md b/docs/machine-learning/package-management/install-additional-python-packages-on-sql-server.md
@@ -3,7 +3,7 @@ title: Install Python packages with sqlmlutils
 description: Learn how to use Python pip to install new Python packages on an instance of SQL Server Machine Learning Services.
 ms.prod: sql
 ms.technology: machine-learning
-ms.date: 06/29/2020
+ms.date: 08/26/2020
 ms.topic: how-to
 author: garyericson
 ms.author: garye
@@ -18,6 +18,7 @@ monikerRange: ">=sql-server-ver15||>=sql-server-linux-ver15||=azuresqldb-mi-curr
 ::: moniker range=">=sql-server-ver15||>=sql-server-linux-ver15||=sqlallproducts-allversions"
 This article describes how to use functions in the [**sqlmlutils**](https://github.com/Microsoft/sqlmlutils) package to install new Python packages to an instance of [Machine Learning Services on SQL Server](../sql-server-machine-learning-services.md) and on [Big Data Clusters](../../big-data-cluster/machine-learning-services.md). The packages you install can be used in Python scripts running in-database using the [sp_execute_external_script](https://docs.microsoft.com/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql) T-SQL statement.
 ::: moniker-end
+
 ::: moniker range="=azuresqldb-mi-current||=sqlallproducts-allversions"
 This article describes how to use functions in the [**sqlmlutils**](https://github.com/Microsoft/sqlmlutils) package to install new Python packages to an instance of [Azure SQL Managed Instance Machine Learning Services](/azure/azure-sql/managed-instance/machine-learning-services-overview). The packages you install can be used in Python scripts running in-database using the [sp_execute_external_script](https://docs.microsoft.com/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql) T-SQL statement.
 ::: moniker-end
@@ -43,9 +44,9 @@ For more information about package location and installation paths, see [Get Pyt
 
 + Packages must be compliant with the version of Python you have, and the version of Python on the server must match the version of Python on the client computer. For information on which version of Python is included with each SQL Server version, see the [Python and R versions](../sql-server-machine-learning-services.md#versions). To confirm the version of Python in a particular SQL instance, see [View the version of Python](python-package-information.md#bkmk_SQLPythonVersion).
 
-+ The Python package library is located in the Program Files folder of your SQL Server instance and, by default, installing in this folder requires administrator permissions. For more information, see [Package library location](../package-management/python-package-information.md#default-python-library-location).
++ Package installation is specific to the SQL instance, database, and user you specify in the connection information you provide to **sqlmlutils**. To use the package in multiple SQL instances or databases, or for different users, you'll need to install the package for each one. The exception is that if the package is installed using the database administrator account, then the package is available to all users in that database.
 
-+ Package installation is per instance. If you have multiple instances of Machine Learning Services, you must add the package to each one.
++ The Python package library is located in the Program Files folder of your SQL Server instance and, by default, installing in this folder requires administrator permissions. For more information, see [Package library location](../package-management/python-package-information.md#default-python-library-location).
 
 + Before adding a package, consider whether the package is a good fit for the SQL Server environment.
 
@@ -93,7 +94,7 @@ You can also install **sqlmlutils** from a zip file:
 
 ## Add a Python package on SQL Server
 
-Using **sqlmlutils**, you can add Python packages to a SQL instance. You can then use those packages in your Python code running in the SQL instance.
+Using **sqlmlutils**, you can add a Python package to a SQL instance. You can then use those packages in your Python code running in the SQL instance. **sqlmlutils** uses [CREATE EXTERNAL LIBRARY](../../t-sql/statements/create-external-library-transact-sql.md) to install the package and each of its dependencies.
 
 In the following example, you'll add the [text-tools](https://pypi.org/project/text-tools/) package to SQL Server.
 
diff --git a/docs/machine-learning/package-management/install-additional-r-packages-on-sql-server.md b/docs/machine-learning/package-management/install-additional-r-packages-on-sql-server.md
@@ -34,6 +34,8 @@ This article describes how to use functions in the [**sqlmlutils**](https://gith
 
 ### Other considerations
 
+- Package installation is specific to the SQL instance, database, and user you specify in the connection information you provide to **sqlmlutils**. To use the package in multiple SQL instances or databases, or for different users, you'll need to install the package for each one. The exception is that if the package is installed using the database administrator account, then the package is available to all users in that database.
+
 - R script running in SQL Server can use only packages installed in the default instance library. SQL Server cannot load packages from external libraries, even if that library is on the same computer. This includes R libraries installed with other Microsoft products.
 
 - On a hardened SQL Server environment, you might want to avoid the following:
diff --git a/docs/t-sql/statements/alter-external-library-transact-sql.md b/docs/t-sql/statements/alter-external-library-transact-sql.md
@@ -2,7 +2,7 @@
 description: "ALTER EXTERNAL LIBRARY (Transact-SQL)"
 title: "ALTER EXTERNAL LIBRARY (Transact-SQL) | Microsoft Docs"
 ms.custom: ""
-ms.date: 06/10/2020
+ms.date: 08/26/2020
 ms.prod: sql
 ms.reviewer: ""
 ms.technology: machine-learning
@@ -141,7 +141,7 @@ WITH ( LANGUAGE = <language> )
 
 **library_name**
 
-Specifies the name of an existing package library. Libraries are scoped to the user. Library names are must be unique within the context of a specific user or owner.
+Specifies the name of an existing package library. Libraries are scoped to the user. Library names must be unique within the context of a specific user or owner.
 
 The library name cannot be arbitrarily assigned. That is, you must use the name that the calling runtime expects when it loads the package.
 
@@ -215,6 +215,8 @@ For the Python language, the package in a .whl or .zip file must be prepared in
 
 The `ALTER EXTERNAL LIBRARY` statement only uploads the library bits to the database. The modified library is installed when a user runs code in  [sp_execute_external_script (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql.md) that calls the library.
 
+A number of packages, referred to as *system packages*, are pre-installed in a SQL instance. System packages cannot be added, updated, or removed by the user.
+
 ## Permissions
 
 By default, the **dbo** user or any member of the role **db_owner** has permission to run ALTER EXTERNAL LIBRARY. Additionally, the user who created the external library can alter that external library.
diff --git a/docs/t-sql/statements/create-external-library-transact-sql.md b/docs/t-sql/statements/create-external-library-transact-sql.md
@@ -2,7 +2,7 @@
 description: "CREATE EXTERNAL LIBRARY (Transact-SQL) - SQL Server"
 title: "CREATE EXTERNAL LIBRARY (Transact-SQL) - SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: 06/10/2020
+ms.date: 08/26/2020
 ms.prod: sql
 ms.reviewer: ""
 ms.technology: machine-learning
@@ -142,7 +142,9 @@ WITH ( LANGUAGE = <language> )
 
 **library_name**
 
-Libraries are added to the database scoped to the user. Library names must be unique within the context of a specific user or owner. For example, two users **RUser1** and **RUser2** can both individually and separately upload the R library `ggplot2`. However, if **RUser1** wanted to upload a newer version of `ggplot2`, the second instance must be named differently or must replace the existing library. 
+Libraries uploaded to the instance can be either public or private. If the library is created by a member of `dbo`, the library is public and can be shared with all users. Otherwise, the library is private to that user only.
+
+Library names must be unique within the context of a specific user or owner. For example, two users **RUser1** and **RUser2** can both individually and separately upload the R library `ggplot2`. However, if **RUser1** wanted to upload a newer version of `ggplot2`, the second instance must be named differently or must replace the existing library.
 
 Library names cannot be arbitrarily assigned; the library name should be the same as the name required to load the library in the external script.
 
@@ -223,6 +225,8 @@ The `CREATE EXTERNAL LIBRARY` statement uploads the library bits to the database
 
 Libraries uploaded to the instance can be either public or private. If the library is created by a member of `dbo`, the library is public and can be shared with all users. Otherwise, the library is private to that user only.
 
+A number of packages, referred to as *system packages*, are pre-installed in a SQL instance. System packages cannot be added, updated, or removed by the user.
+
 ## Permissions
 
 Requires the `CREATE EXTERNAL LIBRARY` permission. By default, any user who has **dbo** who is a member of the **db_owner** role has permissions to create an external library. For all other users, you must explicitly give them permission using a [GRANT](https://docs.microsoft.com/sql/t-sql/statements/grant-database-permissions-transact-sql) statement, specifying CREATE EXTERNAL LIBRARY as the privilege.
diff --git a/docs/t-sql/statements/drop-external-library-transact-sql.md b/docs/t-sql/statements/drop-external-library-transact-sql.md
@@ -2,7 +2,7 @@
 description: "DROP EXTERNAL LIBRARY (Transact-SQL)"
 title: "DROP EXTERNAL LIBRARY (Transact-SQL) | Microsoft Docs"
 ms.custom: ""
-ms.date: 06/10/2020
+ms.date: 08/26/2020
 ms.prod: sql
 ms.reviewer: ""
 ms.technology: machine-learning
@@ -69,6 +69,8 @@ An informational message is returned if the statement was successful.
 
 Unlike other `DROP` statements in SQL Server, this statement supports specifying an optional authorization clause. This allows **dbo** or users in the **db_owner** role to drop a package library uploaded by a regular user in the database.
 
+A number of packages, referred to as *system packages*, are pre-installed in a SQL instance. System packages cannot be added, updated, or removed by the user.
+
 ## Examples
 
 ::: moniker range=">=sql-server-2017||>=sql-server-linux-ver15||=sqlallproducts-allversions"
