Method __CreateUsers

class/databaseModel/pgsqlModel.py:1138–1168

@创建数据库用户

(self, sid, data_name, username, password, address)

    # 本地创建数据库
    def __CreateUsers(self, sid, data_name, username, password, address):
        """
        @创建数据库用户

        """
        sql_obj = self.get_sql_obj_by_sid(sid)
        sql_obj.execute("""CREATE USER "{}" WITH PASSWORD '{}';""".format(username, password))
        sql_obj.execute("""GRANT ALL PRIVILEGES ON DATABASE "{}" TO "{}";""".format(data_name, username))
        sql_obj.execute("""CREATE SCHEMA AUTHORIZATION "{}";""".format(username))
        major_version = self.GetMainVersion(None)
        if major_version >= 15:
            sql_obj.execute("""GRANT USAGE, CREATE ON SCHEMA public TO "{}";""".format(username))
            status, err_msg = sql_obj.use_database(data_name)
            #sql_obj.execute("""GRANT USAGE, CREATE ON SCHEMA public TO "{}";""".format(username))
            sql_obj.execute("""GRANT USAGE, CREATE ON SCHEMA public TO "{}";""".format(username))
        
            # # 授予 public schema 中所有表的权限
            # sql_obj.execute("""GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "{}";""".format(username))
            
            # # 授予 public schema 中所有序列的权限
            # sql_obj.execute("""GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO "{}";""".format(username))
            
            # # 授予 public schema 中所有函数的权限
            # sql_obj.execute("""GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO "{}";""".format(username))
            
            # # 设置未来创建的表的默认权限（重要！）
            # sql_obj.execute("""ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO "{}";""".format(username))
            # sql_obj.execute("""ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO "{}";""".format(username))
            # sql_obj.execute("""ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON FUNCTIONS TO "{}";""".format(username))

        return True

    # def __CreateUsers2(self, sid, data_name, username, password, address):
    #     """