| |

VerySource

 Forgot password?
 Register
Search
View: 10|Reply: 2

In Oracle, can I give users permission to see only the specified tables and views?

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-3-13 18:00:01
| Show all posts |Read mode
RT
How to set it up?
Thank you for your excellent suggestion!
Reply

Use magic Report

0

Threads

8

Posts

7

Credits

Newbie

Rank: 1

Credits
7

 Invalid IP Address

Post time: 2020-6-9 22:15:01
| Show all posts
grant select on table to user
Pay right
Reply

Use magic Report

0

Threads

68

Posts

47

Credits

Newbie

Rank: 1

Credits
47

 China

Post time: 2020-6-10 06:45:01
| Show all posts
A common role-role
All users with this role have specific permissions that the role has

such as:
create role r_acter_user;
grant create session to r_acter_user;
grant select on dba_users to r_acter_user;
grant create trigger to r_acter_user;
Grant this role to the user myuser; then: myuser has all the permissions that the role above has:
grant r_acter_user to myuser;
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list