readonly access on tables

[navee]

Hi, We have a SQL server database on remote server. We are using ODBC
connection to read and write into the table. But we have another user wants to
retrieve(readonly access) our data on his pages. How can we create a user on
our database and grant readonly access to that user? Thanks..

[DixieGal]

If you have access to your database via Enterprise manager,
you should be able to create a user with select privileges only.
No Insert/Update/Delete/Grant privs.

If you do not have access to Enterprise Manager, or your host has user
names locked up in admin, get them to create a select only user for that
database or series of tables. Then TEST it to ensure it works as you would
like
before handingit out :)

--
Tami
aka DixieGal

**************************
The brain is a wonderful organ. It starts working the moment you get up in
the morning
and does not stop until you get into the office.
--Robert Frost
**************************
"navee" <webforumsuser@macromedia.com> wrote in message
news:d02eba$81m$1@forums.macromedia.com...
| Hi, We have a SQL server database on remote server. We are using ODBC
| connection to read and write into the table. But we have another user
wants to
| retrieve(readonly access) our data on his pages. How can we create a user
on
| our database and grant readonly access to that user? Thanks..
|

[kyle969]

Since you will have to set up another datasource in cfAdmin anyway, use the same DB user but restrict to select only.

If that user has access to cold fusion administrator, nevermind :P