Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Grant create view privileges, Is it possible ta grant create view only for one another user
pascalus
post Apr 13 2017, 03:18 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 13-April 17
Member No.: 51,904



Hi,

I exlpain my issue with privileges :

I have oracle 11G database with 10 users.

i use default user named 'user1', i need to be able to create view on 'user2' but not on others users ('user3','user4') for security reasons, so i can't use "create any view"

Is there a simple solution (not to browse all the tables...) with grant or role ?


Thanks you,
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2017 - 09:24 AM