当前位置:网站首页>opengauss创建用户权限问题
opengauss创建用户权限问题
2022-08-11 07:43:00 【Asky】
创建了一个用户,但是没有权限操作public的权限
db_test=> create table public.tb_test(id number,name varchar(32));
ERROR: permission denied for schema public
DETAIL: N/A
报该错误,然后赋予grant all privileges to hxl;这个权限,但是这个权限很大,是否有办法创建一个只能操作某个库的账号呢
openGauss=# grant all privileges to hxl;
ALTER ROLE
openGauss=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------------------------------------------------------------+-----------
hxl | Sysadmin | {}
omm | Sysadmin, Create role, Create DB, Replication, Administer audit, Monitoradmin, Operatoradmin, Policyadmin, UseFT | {}
其他答案1:
grant create,usage on schema public to hx1;
边栏推荐
- There may be fields that cannot be serialized in the abnormal object of cdc and sqlserver. Is there anyone who can understand it? Help me to answer
- 【TA-霜狼_may-《百人计划》】图形3.7.2 command buffer简
- Decrement operation in tf; tf.assign_sub()
- 动态代理学习
- Four states of Activity
- 测试用例很难?有手就行
- 1081 Check Password (15 points)
- 分布式锁-Redission - 缓存一致性解决
- Evolution and New Choice of Streaming Structured Data Computing Language
- 2022 China Soft Drink Market Insights
猜你喜欢
零基础SQL教程: 基础查询 05
项目1-PM2.5预测
我的创作纪念日丨感恩这365天来有你相伴,不忘初心,各自精彩
1091 N-Defensive Number (15 points)
About # SQL problem: how to set the following data by commas into multiple lines, in the form of column display
机器学习总结(二)
通过记账,了解当月收支情况
leetcode: 69. Square root of x
Square, multi-power, square root calculation in Tf
One-hot in TF
随机推荐
matplotlib
1056 Sum of Combinations (15 points)
1051 复数乘法 (15 分)
线程交替输出(你能想出几种方法)
1051 Multiplication of Complex Numbers (15 points)
Write a resume like this, easy to get the interviewer
Distributed Lock-Redission - Cache Consistency Solution
CSDN21天学习挑战赛——封装(06)
XXL-JOB 分布式任务调度中心搭建
The most complete documentation on Excel's implementation of grouped summation
redis操作
CIKM 2022 AnalytiCup Competition: Federal Heterogeneous Task Learning
动态代理学习
2022年中国软饮料市场洞察
Four startup modes of Activity
囍楽云任务源码
8、Mip-NeRF
tf.cast(),reduce_min(),reduce_max()
如何仅更改 QGroupBox 标题的字体?
1106 2019 Sequence (15 points)