Shared Folders snap-in...

From: Rajen (rajenspirut@yahoo.com)
Date: 03/18/03 

From: "Rajen" <rajenspirut@yahoo.com>
Date: Mon, 17 Mar 2003 18:13:03 -0800

We have a database that needs to be viewed by the whole
company, so for ease of access I have placed it on our
server (Win2K) in a shared folder. Unfortunately every
time the database author needs to make changes, he must
ensure that no one is connected to it. This requires him
calling and having me check with MMC to see who's
connected. I would like to give him the ability to view
the connections himself but keep him as a restricted
user. All the documentation I have read says that one
MUST be an admin or power user to view through MMC. Is
there a way to create a user group that just has access
to the Shared Folders snap-in? I have tried publishing
the folder to Active Directory and delegating control
with no luck.

Any ideas would be greatly appreciated!
Rajen

Relevant Pages

  • Re: How can I open an SQL database and be the only one who has access to it?
    ... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
    (microsoft.public.data.ado)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors. ...
    (comp.databases.oracle.server)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors. ... that Oracle is having issues with OS resources. ...
    (comp.databases.oracle.server)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... New server has 6GB ram. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ...
    (comp.databases.oracle.server)
  • Re: How to handle large number of users
    ... The client app will work on mobile phones using WinCE and it is just a small app updating some tables in the database on the server. ... use a Database Pooling mechanism, that controlled the number of active connections to the DB server through the pool. ... You are not going to be storing mountains of data, the streams will be small and the data capture should be relatively small (unless you are collecting transaction times, rates, etc). ... Lets assume that your transaction rate for inserting and/or updating the database for the 10K data stream is 100 milliseconds. ...
    (borland.public.delphi.non-technical)