Role Base Security for Oracle


Author
Message
Guillermo Vilas
Guillermo Vilas
StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)StrataFrame User (212 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 2.3K
Hello
Does anyone has the scripts to create the role base security tables under Oracle? That will save a lot of time rewriting the ones supplied for sql 2005.

Thanks in advanced

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion

StrataFrame Team
S
StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)StrataFrame Developer (4.7K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
I haven't created one.  Although I will warn you that once the auditing becomes available for the security module, it will be a SQL Server 2005 only feature because the auditing records are stored in XML columns.  So, you might consider using SQL Server 2005 Express for just security and Oracle for your application itself... the security tables are referenced very seldomly, and the 4GB limit is definitly big enough to handle 4 million plus users and permissions...
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search