Hi
I need some design info. Say that I need to create an educational lab
for databases with SQL Server. I need all the users to be able to
execute common SQL commands ( create - alter – drop table , insert ,
update , delete ) and each user have his own space ( users not able to
see others data and a limit say of 2 MB) . The most obvious solution
is to create ( if I have 100 users ) , 100 login account ( SQL Server
Accounts ) , then create 100 databases , and assign each user to one
of this account with database role db_datawriter. Is this the best
solution or there is another way to do it ?
Thanks 3 1391
"db_happy" <da******@freem ail.gr> wrote in message
news:b6******** *************** ***@posting.goo gle.com... Hi
I need some design info. Say that I need to create an educational lab for databases with SQL Server. I need all the users to be able to execute common SQL commands ( create - alter - drop table , insert , update , delete ) and each user have his own space ( users not able to see others data and a limit say of 2 MB) . The most obvious solution is to create ( if I have 100 users ) , 100 login account ( SQL Server Accounts ) , then create 100 databases , and assign each user to one of this account with database role db_datawriter. Is this the best solution or there is another way to do it ?
Thanks
If you need to limit the users' space, then individual databases are
probably the only way to go, since there's no way to manage space quotas
within a single database. (At least, there's no standard way without using a
third party tool or building your own quota tools.) Note that db_datawriter
cannot create objects, so you would need to add the user to db_ddladmin
also, or create a custom role with the permissions set you want.
The downside of this approach is management of the large number of databases
and the associated files, backups etc. However, if you always use standard
scripts for creating/dropping each database, leverage Windows groups for
authentication (if possible), and perhaps use SQL maintenance plans for
backups, then you should be able to keep the work required to a minimum.
Simon
Hi
You could buy each a copy of developer edition and let them run it on their
own PCs! A cheaper solution would be to use MSDE.
John
"db_happy" <da******@freem ail.gr> wrote in message
news:b6******** *************** ***@posting.goo gle.com... Hi
I need some design info. Say that I need to create an educational lab for databases with SQL Server. I need all the users to be able to execute common SQL commands ( create - alter - drop table , insert , update , delete ) and each user have his own space ( users not able to see others data and a limit say of 2 MB) . The most obvious solution is to create ( if I have 100 users ) , 100 login account ( SQL Server Accounts ) , then create 100 databases , and assign each user to one of this account with database role db_datawriter. Is this the best solution or there is another way to do it ?
Thanks
On Sun, 11 Jul 2004 17:39:20 GMT, John Bell wrote: Hi
You could buy each a copy of developer edition and let them run it on their own PCs! A cheaper solution would be to use MSDE.
John
"db_happy" <da******@freem ail.gr> wrote in message news:b6******** *************** ***@posting.goo gle.com... Hi
I need some design info. Say that I need to create an educational lab for databases with SQL Server. I need all the users to be able to execute common SQL commands ( create - alter - drop table , insert , update , delete ) and each user have his own space ( users not able to see others data and a limit say of 2 MB) . The most obvious solution is to create ( if I have 100 users ) , 100 login account ( SQL Server Accounts ) , then create 100 databases , and assign each user to one of this account with database role db_datawriter. Is this the best solution or there is another way to do it ?
Thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Andrea Griffini |
last post by:
I did it.
I proposed python as the main language for our next CAD/CAM
software because I think that it has all the potential needed
for it. I'm not sure yet if the decision will get through, but
something I'll need in this case is some experience-based set
of rules about how to use python in this context.
For example... is defining readonly attributes in classes
worth the hassle ? Does duck-typing scale well in complex
|
by: Kymert persson |
last post by:
Hi.
I was wondering if there are any more C++ books along the lines of
"Large scale C++ software design" by Lakos, J. I.e. concerning larger
design issues in close relation to C++. I have made a fairly thorough
literature search, but i haven't found anything fitting this criteria.
In general there seems to be a huge amount concerning the C++ language as
such and more "narrow" design issues, e.g. along the lines of Meyers
Effective-
|
by: eMKa |
last post by:
Hi Code guru's
I have created a user control which has access, and thus makes use of a shared singleton class like:
Dim MyAppSettings As DLAppSettings = DLAppSettings.GetAppSettings
This singleton class has amongst other stuff the following line of code in it:
Private m_DL_DBPath As String = System.Configuration.ConfigurationSettings.AppSettings("DMDatabasePath")
As you guess, it must read a string containing the path. Based on this...
|
by: John Holmes |
last post by:
This, I fear, is related to the fact that Visual Studio.NET reformats the
HTML when going into design mode and then back out. I have an object tag
that is using an object provided by a 3rd party vendor to use their
signature pad. I set the <PARAM .. > tags and if I need to go into design
mode it gets rid of the <PARAM> tags that I put in and puts every possible
PARAM tag in with settings it gets from somewhere. This is very annoying.
I...
|
by: keliie |
last post by:
I have a relatively simple (I assume) issue which I am at a complete
loss to address. My issues is: I want to populate fields in my tables
with summary data from the same table. Let me explain:
tblItemDetails (contains data on food products purchased)
Item_Description_ID (key, source link to tblMenuItemRecipe)
Item_Unit_of_Measure
Item_Location
Item_Type
Item_Category
| |
by: YellowFin Announcements |
last post by:
Introduction
Usability and relevance have been identified as the major factors
preventing mass adoption of
Business Intelligence applications. What we have today are traditional
BI tools that don't work
nearly as well as they should, even for analysts and power users. The
reason they haven't
reached the masses is because most of the tools are so difficult to use
and reveal so little
|
by: Paul Hadfield |
last post by:
I'm looking for thoughts on the "correct" design for this problem (DotNet
2.0 - in winforms, but that's not so important). I've got two combo boxes
(combo1 and combo2), both are populating via database calls (using a
separate DB handler class). "combo1" contains a list of countries and is
fairly static, it can be added to but no other external events cause a
change in its population. "combo2" however is populated with a list of
options...
|
by: obrianpatrick |
last post by:
Hi,
I am relatively new to object oriented programming and design. I am
developing an application in VS 2005. I am having the following design
problem:
I have two interfaces X and Y. Y is derived from X as the following:
__interface X
{
|
by: pgrazaitis |
last post by:
I cant seem to get my head wrapped around this issue, I have myself so
twisted now there maybe no issue!
Ok so I designed a class X that has a few members, and for arguments
sake one of the members Y is the location of a file to be read. The
original design assumes that this class will be instantiated and each
instance will happily mange its own members. (ie One file location
per instance...no thread-safety).
Now another class A...
|
by: Ken Fine |
last post by:
I've been living with a frustrating issue with VS.NET for some months now
and I need to figure out what the problem is. Hopefully someone has run into
the same issue and can suggest a fix. I suspect some permissions problem.
I'm running VS.NET 2008 in Vista. Symptoms and observations:
* ASP.NET's native ImageMap and Image controls work just fine and provide a
design-time preview of images that are referenced via the ImageUrl property
*...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |