Role Base Security for Oracle


Author
Message
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...
Guillermo Vilas
Guillermo Vilas
StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 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

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