Hi to all,
In our environment we are strictly limiting the users to get access on what
the don' t need ( application users and developers have their own role ( and
are granted only on the things the need to access) ).
When one of them logs in he can only see his own objects but he will be able
to access to all STORED PROCEDURES there are. This means that whoever has t
he Management Console installed ( or use a thirth party application ) can a
ccess ( alter/delete ) stro
red procedures ( and jobs ( see other post in this forum ))
How to prevent this'
Thanx in advance,
GKramerThere is currently not a way in Enterprise Manager to prevent users from
viewing stored procedures.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Rand,
I'm an experianced Oracle DBA and wonder why SQL server is not providing opt
imal security ?
I hope Yukon provides a better security system where you can access you own
objects and grant others too ( or revoke them for having access ).
GKramer
The Netherlands
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment