role 冲突 PRIVILEGE
I have create a role as following steps: 1, create role query_role 2, grant select on table1 to query_role 3, grant query_role to user1 4, revoke all on table1 from public 5, set role query_role Login in using user1: select * from table1; error: no SELECT permission set role query_role the select statment worked I don't want to set role every time after login in. How can i do? Thank:roll:...
by juliey - Informix - 2006-08-10 01:21:06 阅读（1557） 回复（3）
I would like to control some users don't update, insert or delete data from tables. But in Informix when I grant the "CONNECT" to the users. They got the update tables privilege. How can I control that? Thanks :oops:
create user lyp identified by lyp default role dba 说default role子句对create user无效果，书上明明也是这样做的嘛
我创建一个角色doctor_role,将其授予一个用户,再做set role doctor_role on,但显示:SET role fails. The caller is not granted with the specified role. Please contact a user with System Security Officer (SSO) role for help. 有谁个仁兄知道?
Anybody can tell me this two question: 1. What kind of SQL server role and database role needed for monitor the SQL jobs? 2. What kind of server role and database role needed for run bcp utility? \" System Administrator\" is the only answer? anything else? Thanks,
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
最终解决方法如下：
在mysql的安装目录下，我的是/usr/bin
./mysql_install_db --user=mysql --datadir=/var/lib/mysql
原因是重装的时候数据目录不一致导致
然后再次启动，OK
moose中的role 应该翻译成啥？ 看moose：：manual：：attributes下面的code求注释 package HasSize; use Moose::role; requires '_build_size'; has 'size' => ( is => 'ro', lazy => 1, builder => '_build_size', ); package Lilliputian; use Moose; with 'HasSize'; sub _build_size { return 'small' }
招聘公司 ：世界５００强ＩＴ公司 工作地点：上海或成都 [td=1,1,132] Location [td=1,1,492]Shanghai and Chengdu [td=1,1,132] Required Skills [td=1,1,492]• Fluent English writing/reading/speaking ability. • At least 6 years of experience in SAP consulting and at least 3 years of experience in project management or department management • Good technical expertise with negotiation...
