开发者

grant privilege to another user

开发者 https://www.devze.com 2023-01-20 16:23 出处:网络
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 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

精彩评论

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