Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SGA and db sizing tips
I am running a small dev server (Windows 2K) with Oracle 8.1.7, I would like to run two instances; one for the RMAN and OEM repository and the other for developing. I have experimented by creating two instances using the DBCA and left the defaults. I have run both of these with the Management...- Skylined
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
grant drop view ...
I need to 'GRANT DROP VIEW TO ...' but this is not possible. Is there any way I can give a login rights tp do this in an individual database? I though of creating a db role specifically for this but can't figure how to give the role ability to 'DROP VIEW'. Any help would be gladly appreciated...- Skylined
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
