建视图遇到的问题! 你的book表是建立在sys用户下面的吗?如果不是,应该用user.book才能访问 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是不是每一个BOOK前面都要加user 把? 以DBA身份登陆,然后把所建的视图的相应权限授予相应的用户。grant select on view viewname to username CREATE VIEW dbo.V_Book_JsASSELECT Book.kcbm, Book.Xnxqh, Book.Sl, Book.ID, Book.JcXh, Book.BH, Book.Flag, Curriculum.Kcmc, Book.Jsbh, Teacher.Jsxm, Book.JcID, JiaoCaiKC.JCname, JiaoCaiKC.JCzzname, JiaoCaiKC.Jcbc, JiaoCaiKC.JCcbs, JiaoCaiKC.ISBN, JiaoCaiKC.JCdj, JiaoCaiKC.JCkucun, Book.FfSlFROM Book INNER JOIN Curriculum ON Book.kcbm = Curriculum.kcbm LEFT JOIN Teacher ON Book.Jsbh = Teacher.Jsbh LEFT JOIN JiaoCaiKC ON Book.JcID = JiaoCaiKC.JcID你试试 你先执行这个SQLSELECT Book.kcbm, Book.Xnxqh, Book.Sl, Book.ID, Book.JcXh, Book.BH, Book.Flag, Curriculum.Kcmc, Book.Jsbh, Teacher.Jsxm, Book.JcID, JiaoCaiKC.JCname, JiaoCaiKC.JCzzname, JiaoCaiKC.Jcbc, JiaoCaiKC.JCcbs, JiaoCaiKC.ISBN, JiaoCaiKC.JCdj, JiaoCaiKC.JCkucun, Book.FfSlFROM Book INNER JOIN Curriculum ON Book.kcbm = Curriculum.kcbm LEFT JOIN Teacher ON Book.Jsbh = Teacher.Jsbh LEFT JOIN JiaoCaiKC ON Book.JcID = JiaoCaiKC.JcID能否查出东西 就是权限问题,你把要查询的所有表的select权限赋给sysdba用户即可! 谁有oracle 4516865 补丁 varchar2类型的,咋就说我没定义呢? oracle怎样获得当前月份前一年12月份的日期 如何获取自某个时间以来改动过的记录? 求一条高效的sql语句 ▲求“分组进行编序号”的SQL startup 哪位高手指点下!oracle菜鸟关于存储过程中编写循环的问题!!!!急!+急+++++++++急!!!!! pl/sql中表名是个变量改怎么办? oracle连接、登入问题 请教一个SQL语句 操作系统瘫痪,oracle数据库数据 还可以恢复吗?
grant select on view viewname to username
AS
SELECT Book.kcbm, Book.Xnxqh, Book.Sl, Book.ID, Book.JcXh, Book.BH, Book.Flag,
Curriculum.Kcmc, Book.Jsbh, Teacher.Jsxm, Book.JcID, JiaoCaiKC.JCname,
JiaoCaiKC.JCzzname, JiaoCaiKC.Jcbc, JiaoCaiKC.JCcbs, JiaoCaiKC.ISBN,
JiaoCaiKC.JCdj, JiaoCaiKC.JCkucun, Book.FfSl
FROM Book INNER JOIN
Curriculum ON Book.kcbm = Curriculum.kcbm LEFT JOIN
Teacher ON Book.Jsbh = Teacher.Jsbh LEFT JOIN
JiaoCaiKC ON Book.JcID = JiaoCaiKC.JcID
你试试
SELECT Book.kcbm, Book.Xnxqh, Book.Sl, Book.ID, Book.JcXh, Book.BH, Book.Flag,
Curriculum.Kcmc, Book.Jsbh, Teacher.Jsxm, Book.JcID, JiaoCaiKC.JCname,
JiaoCaiKC.JCzzname, JiaoCaiKC.Jcbc, JiaoCaiKC.JCcbs, JiaoCaiKC.ISBN,
JiaoCaiKC.JCdj, JiaoCaiKC.JCkucun, Book.FfSl
FROM Book INNER JOIN
Curriculum ON Book.kcbm = Curriculum.kcbm LEFT JOIN
Teacher ON Book.Jsbh = Teacher.Jsbh LEFT JOIN
JiaoCaiKC ON Book.JcID = JiaoCaiKC.JcID
能否查出东西