NewGuyinTown
Mar 11 2006, 05:33 PM
| | I want to know which is the most efficient way to create accounts and logins.
I have trouble deciding which is the better of the three:
- User Priveileges
- TABLES
- Rows |
Reply
yordan
Mar 11 2006, 10:28 PM
Depends from what you want to do. If you have several groups of people, you can place the first set of people in the same group. then give group privilege to their tables. So, all the people in the same group will be able to share the same info. People from other groups will have no privilege to these tables, for instance they will be able to read info but not to add. Of course, if you are talking about the files permissions, it's different. the owner of the database (you, probably) must have access to all the files, and probably no one other, except the database admin.
Reply
Similar Topics
Keywords : user, priveileges, tables, rows, method, accounts, logins
- Mysql Multiple Tables
(1)
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
Mysql Problem
Linking tables (1) Hello guys, I'm making a PHP/MySQL site for a friend of mine who plays an online game where you
can create towns, add buildings to them and upgrade them to a newer level. I've offered to make
him a small site where he can input his data into a database and keep track of his towns, buildings
and levels. I'll show you my database design and then explain what i want to do. Table: towns
field 1: TownID (primary key, auto-increment) field 2: TownName field 3: TownType field 4: Town
Description Table: buildings field 1: BuildingID (primary key, auto-incremen....
Script Tables On Sql Server Compact
(0) So I have an application that's using SQL Server Compact Edition 2005. I need to export the
table schema to a file of SQL statements, containing only the schema...no data, no rows, just the
tables, indexes, and constraints. Now, when using SQL 2000/2005 I just use the script table as...
feature to do exactly this, but because SQL server Compact Edition doesn't have the support for
it, I can't do this. The tables in SQL Server Compact *do* have the information_schema views
though, so I was wondering if anyone knows of any tools that can read these views and....
(help With Sql And Php)retrive Datas From Realted Tables And Display Them!
Please help me to diplay datas by combining 3 tables! (4) Hi all.. Please help me to write the SQL Query for the following requirement! Im having 3 MySQL
tables Sales_users Sales_products Sales_details 1st Table (Sales_users) contains unique userID
and username for the users! 2nd Table (Sales_products) Contains unique Product ID, product Name and
Product Description! 3rd Table (Sales_details) contacins unique Sales ID, Product ID (Foreign Key),
FromUser (Foreign Key) and ToUser (Foreign Key) Sales_users
User_id name 1 Test1 ....
Linking Two Tables
(12) I have two tables in a database. userid and usercredits In userid I have all the fields that
identify the user (name, address etc.) In my usercredits table I have the following fields: IDNUM
ProgramName Camp# CompletionDate Amount DatePmtSent PmtMethod Comments creditID What I would like
to understand about my table structure, is how do I associate my credits tothe correct user. If I
have done this correctly, there is also a field in the first table that is called IDNUM where each
user has a unique number to identify who they are. When someone is logged into the ....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
Updating A Database's Tables
(10) Is there an "easy" way to update a database's tables? Like for instance, I have my own
custom-coded member login system. Whenever I add a new feature that needs a database, I manually
have to download, update and upload the database. Is there an easy way I can do this? THANKS!!! F....
Creating Tables In MySQL On Home Comp
(8) Hi, I've tried seraching for a bit, but I couldn't find an answer to my questions.
Recently I've succesfully installed Apache on my Windows XP Machine, along with PHP and mySQL. I
need a database on my computer for testing purposes. I've enables mySQL in PHP, and both seems
to be working fine. I can connect to the database, but how do I edit the database? E.g., edit rows
or modify columns. I would much rather stay away from using the command-line stuff. I'm looking
for a GUI Query program that I can use, but I have no clue which one to choose. It ....
phpBB To php-Nuke
User want to transfer. (4) One of my users wants to transfer the data and so on from his phpBB2 to his PHP-Nuke CMS. I offered
a link to Nuke Code that had 8 programs that deal with such matters. He replys that that is not
really what he wants, to that the only response I could give was that since all he wanted to do was
to export his phpbb_users table to his nuke_users table. To this reply he seemed to get the result
he wanted but then stated that some of hid files as imported caused errors and I am sure this is the
way he imported or perhaps the way he set up the export sql file How should I ....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
Generating Many Tables
(2) I have a database that will contain 43 tables (among others). For these particular tables, they will
each contain the same type of information, each representing a particular week in the NASCAR season.
I used the following script to create one table: DROP TABLE IF EXISTS gulfOwnerDriversWeek1;
CREATE TABLE gulfOwnerDriversWeek1 ( ownerIndex int primary key, driverIndex1 int, driverIndex2 int,
driverIndex3 int, driverIndex4 int ); This table represents a draft sheet for one particular week
(Week 1) for a particular team. My first question is, should try to put all week....
Selection From Multiple Tables
(0) I am in the middle of creating a little forums system, and all so far is going quite well. However I
have come across a small problem; PHP:
--------------------------------------------------------------------------------
$gather_forums_qry = "SELECT a.frm_id, a.frm_name, a.frm_description,
count(distinct(b.fth_id)) ThreadCount, count(distinct(c.fpt_id))
PostCount, a.frm_enabled, IF( IFNULL( MAX(
b.fth_dateposted), 0) > IFNULL( MAX( c.fpt_datepo....
Looking for user, priveileges, tables, rows, method, accounts, logins
|
*SIMILAR VIDEOS*
Searching Video's for user, priveileges, tables, rows, method, accounts, logins
|
advertisement
|
|
