开发者

grant privilege to another user

I am logging into oracle as a simple user.I want other user who are logged in to the same database as i am ,be able to see and manipulate tabels and stored procedure. I used grant privilege to achieve this.

        grant  all on tablename to user;

but it is not working ie on querying the table it is showing no such table or view exists. Ho开发者_StackOverflow中文版w should i achieve this.


The other user may have to use a schema name when accessing the table. eg. select * from user1.table1

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜