![]() ![]() The new user account is now ready to be used in the PostgreSQL geodatabase. To exit (quit) from the the PostgreSQL interactive terminal, type the following and press Enter.GRANT SELECT, INSERT, UPDATE, DELETE ON public.Geometry_columns TO username If using a database that is PostGIS enabled, additional privileges must be granted to the user:.GRANT USAGE ON SCHEMA username TO PUBLIC Grant usage on the schema to other users:.In this example, the database name is sde:ĬREATE SCHEMA username AUTHORIZATION username This step is necessary only for those users who will own data. Before creating the schema, connect to the database where the schema will be created. The next step is to create a schema for the new user.This creates a new user login, or ROLE as it is called in postgreSQL, and assigns a password. Type the following statement, supplying the desired username and password:ĬREATE ROLE username LOGIN PASSWORD 'password' NOINHERIT CREATEDB.In Windows, go to Start > All Programs > PostgreSQL 8.3 > psql to 'postgres'. This opens up the psql interactive terminal.This article assumes that PostgreSQL has already been installed. Assign appropriate privileges so that other users can access the data in the newly created user's schema.Create a schema for the user if that user will own data within the geodatabase.The commands in this How To article will: The psql PostgreSQL interactive terminal can be used to create additional users in a PostgreSQL ArcGIS Enterprise geodatabase. Settings in the configuration template.Instructions provided below describe how to add a new user to a PostgreSQL geodatabase using the psql interactive terminal. Template settings are merged only for options that are:Ĭommand-line arguments or environment variables take precedence over Command-line options that are not available for executor volumes for Kubernetes.Ĭoncurrent = 1 check_interval = 0 session_timeout = 1800 ] name = "test-runner" url = "" token = glrt- executor = "kubernetes" host = " bearer_token_overwrite_allowed = false image = "" namespace = "" namespace_overwrite_allowed = "" privileged = false service_account_overwrite_allowed = "" pod_labels_overwrite_allowed = "" pod_annotations_overwrite_allowed = "" ] name = "empty_dir" mount_path = "/path/to/empty_dir" medium = "Memory".Size limits on environment variables based on the environment. ![]() The configuration template can be used for automated environments that do not support some arguments Obtain a runner registration token (deprecated) for a shared,.Runner authentication tokens have the prefix, glrt. Locate the runner authentication token in the config.toml file.Obtain a runner authentication token (recommended). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |