怎样按记录授权？

littlelolo

I think,
1) create a table include user_id, eg, table1
2) create a view, eg view1
   select *
   from   table1
   where  user_id = user;
3) for anybody can select, insert, update for his owner records,
   grant select, insert, update on view1 to him
4) for anybody can select all the records
   grant select on table1 to him
5) for anybody can select, update, insert all the records
   grant select,insert, update on table1 to him

流云飞天

oldwain 的回答是正确的。
他说：“ 按记录授权是view的典型用途之一。”

在这里，我详细的说明一下视图的功能，参照我的一篇帖子《“视图的功能”》。
http://www.itpub.net/showthread.php?s=&postid=61621#post61621

manplx

I have a clear picture of it, thanks to all,thanks.

carny

follow ANSI SQL  Standard.
You must create some VIEW to overcome that it is the best way.
另外補充一下
The create view is like logical file in IBM AS/400.
The create table is like phyical file in IBM AS/400.

jiang

Example:
1, create user BASE identified by base;
    create user test1231 identified by test1231;
   create user test0112 identified by test0112;

   grant connect, resource to base, test1231, test0112;

2, connect base/base

  create table test_abc(
  pk number(5) primary key,
  name varchar2(10),
   userid varchar2(30) default user);

CREATE OR REPLACE TRIGGER Gen_test_abc_userid
   Before INSERT ON test_abc
   FOR Each Row
begin
:new.userid:=user;
END;

   create view test_abc_v
     as select * from test_abc where userid=user

   grant all on test_abc_v to test1231, test0112;

3, if you connect test1231/test1231, you can just use records created by test1231;

4, if you connect test0112/test0112, you can just use records created by test0112;

ysc7305

我觉得用视图好一些,在进行编程试方便,同时修改也比较方便.

SEAN

最初由 ysc7305 发布
[B]我觉得用视图好一些,在进行编程试方便,同时修改也比较方便. [/B]

我认为，任何应用程序访问数据库，都应通过VIEW来实现。应该成为开发者的一种习惯和工作小组的规范。