5/31/2023 0 Comments Redshift create user![]() ![]() For more information, see CREATE USER in the Amazon Redshift Database Developer Guide. If a database user matching the value for DbUser doesn't exist and Autocreate is False, then the command succeeds but the connection attempt will fail because the user doesn't exist in the database. If DbUser doesn't exist in the database and Autocreate is True, a new user is created using the value for DbUser with PUBLIC permissions. If a user name matching DbUser exists in the database, the temporary user credentials have the same permissions as the existing user. If the DbName parameter is specified, the IAM policy must allow access to the resource dbname for the specified database name Options In addition, if the AutoCreate parameter is set to True, then the policy must include the redshift:CreateClusterUser privilege. If the DbGroups parameter is specified, the IAM policy must allow the redshift:JoinGroup action with access to the listed dbgroups. For more information about permissions, see Resource Policies for GetClusterCredentials in the Amazon Redshift Cluster Management Guide. The AWS Identity and Access Management (IAM)user or role that executes GetClusterCredentials must have an IAM policy attached that allows access to all necessary actions and resources. For more information, see Using IAM Authentication to Generate Database User Credentials in the Amazon Redshift Cluster Management Guide. You can optionally specify a duration between 900 seconds (15 minutes) and 3600 seconds (60 minutes). By default, the temporary credentials expire in 900 seconds. You can optionally specify one or more database user groups that the user will join at log on. The action returns the database user name prefixed with IAM: if AutoCreate is False or IAMA: if AutoCreate is True. Returns a database user name and temporary password with temporary authorization to log on to an Amazon Redshift database. aws redshift revoke-cluster-security-group-ingress.aws redshift restore-table-from-cluster-snapshot.aws redshift restore-from-cluster-snapshot.aws redshift reset-cluster-parameter-group.aws redshift purchase-reserved-node-offering.aws redshift modify-snapshot-copy-retention-period.aws redshift modify-cluster-subnet-group.aws redshift modify-cluster-snapshot-schedule.aws redshift modify-cluster-parameter-group.aws redshift modify-cluster-maintenance.aws redshift modify-cluster-db-revision.aws redshift get-reserved-node-exchange-offerings.aws redshift describe-table-restore-status.aws redshift describe-snapshot-schedules.aws redshift describe-snapshot-copy-grants.aws redshift describe-scheduled-actions. ![]()
0 Comments
Leave a Reply. |