工作日志－授权，同义词，存储过程生成时间维表数据

同一数据库，访问其它用户的表时，需要授权

grant select on ckm.t_user to cam;

收回权限

revoke select on ckm.t_user from cam;

同一数据库不同用户互相访问，可以建同义词（建同义词也要授权，貌似只是访问时是否要加用户，例from ckm.t_user,有同义词from t_user）

建了个存储过程对时间维表进行初始化数据，还没加索引

create or replace procdure p_init_time(beginDateStr varchar2,endDateStr varchar2)

as

currentYear varchar2(10);

currentMonth varchar2(10);

currentDay varchar2(10)

is

begin

currentDay := beginDateStr;

while(currentDay<=endDateStr)

loop

select substr(currentDay,0,4) into currentYear from dual;

select substr(currentMonth,0,6) into currentMonth from dual;

insert into t_dim_time(Year,Month,Day)values(currentYear,currentMonth,currentDay);

select to_char(to_date(currentDay,'yyyyMMdd')+1,'yyyyMMdd') into currentDay from dual;

end loop;

insert into

end;

/

call p_init_time('20130101','20141231');

drop procdure pp_init_time;