 | |
Create view from DBA_ROLES for non-privileged users?
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Create view from DBA_ROLES for non-privileged users? -
06-13-2008
, 08:10 AM
|
Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. |
Quote:
|
Any other thoughts about the original approach? Why specifically might your solution be preferable? Thanks again. Dana |
#22
| |||
| |||
|
|
Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. |
Quote:
|
Any other thoughts about the original approach? Why specifically might your solution be preferable? Thanks again. Dana |
#23
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
#24
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
#25
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
#26
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
#27
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
#28
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
#29
| |||
| |||
|
|
On 13 Jun, 13:02, dana... (AT) yahoo (DOT) com wrote: Thanks Ana. They prefer to not use stored procedures in my environment, but I will look into it. Out of interest, why? |
1) A standard from higher up in the org to keep all business logic, as
far as possible, out of the data tier and on an application tier
2) A standard from higher up in the org to lessen vendor lock-in by
reducing the use of vendor-specific database features.
They're not my standards and it's all highly debatable.
Dana
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.