hide field from user

I have an app that connects to sqlepress. When run the field are loaded from the db. There are some fields that I don't want some of the users to see. Is there a way to do this without hardcoding the 'username' in the applicaton ?

I looked at the explicit permissions for username for the particular table, but I don't understand some of the terms listed.

Alter

Control

References

View definition

Normally you do this by creating a View that exposes just the columns that you want to show to the users. I don't know of any way to control column level access by user, particularly if you don't tell SQL who the users is. I would say that you create specific groups to control access level, then build Views with the right set of columns for each group. Then you can call the appropriate View based on the group membership.

Mike

sql

Hide an ODBC connection?

We've purchased a 3rd party app that uses an Access db linked to SQL Server. Unfortunately, we've come to discover that a user of ours seems to know access and has decided to take report writing into their own hands.
We have the app and the access db on a server and a mapped a drive for each user.

Unfortunately, I can't lock down the ODBC connection because that would lock it down in the app. Someone suggested using a File DSN and removing the System DSN's off all users machines. I'm not too familiar with File DSN's and wanted to know if this would prevent users from creating their own Access mdb's linked to my server or not.

Any idea's are greatly appreciated.Dude,

Bad news :( - unless you can stop the end user from hacking the registry and prevent access to the odbcad32 (which you really can't lock out and have the machine access the server) there isn't much you can do AFAIK.

You didn't mention what OS's are in play. If you are a Win2k/WinXP shop you may be able to build a policy that limits the user from adding a new DSN, but I doubt even a file DSN will really stop him. If you go look in C:\Program Files\Common Files\ODBC\Data Sources All they really do is point to the system DSN. And he'll be able to pick it in Access.|||I figured the answer would go something like that.
Thank you anyways.

Hi Dan Guzman

hi dan
Some of my pals are facing a very rare kinda problem. Thay have a
Java app that connects to a SQL server instance. Currently they are
testing the app on the same comp where SQL server is installed. Few
days back when they executed the app it couldnt connect to the
database. But yesterday it found a way out. The same thing happened
but this time they restarted SQL server. None of them including me
could figure out what is the problem.
Any advises??

Cheers
DebashishWhat error message was returned when the connection failed? Do you have any
related messages in the SQL Server error log? Check out
http://support.microsoft.com/defaul...kb;en-us;827422.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"debashish" <debashish_majumdar@.rediffmail.com> wrote in message
news:bb05cfc5.0410170408.4ee5f030@.posting.google.c om...
> hi dan
> Some of my pals are facing a very rare kinda problem. Thay have a
> Java app that connects to a SQL server instance. Currently they are
> testing the app on the same comp where SQL server is installed. Few
> days back when they executed the app it couldnt connect to the
> database. But yesterday it found a way out. The same thing happened
> but this time they restarted SQL server. None of them including me
> could figure out what is the problem.
> Any advises??
> Cheers
> Debashish|||Hi

In addition to Dan's reply the following may also help:

http://support.microsoft.com/defaul...kb;en-us;313178

http://support.microsoft.com/defaul...kb;en-us;313100

It would also be useful to know which driver and version of the driver you
are using.

John

"debashish" <debashish_majumdar@.rediffmail.com> wrote in message
news:bb05cfc5.0410170408.4ee5f030@.posting.google.c om...
> hi dan
> Some of my pals are facing a very rare kinda problem. Thay have a
> Java app that connects to a SQL server instance. Currently they are
> testing the app on the same comp where SQL server is installed. Few
> days back when they executed the app it couldnt connect to the
> database. But yesterday it found a way out. The same thing happened
> but this time they restarted SQL server. None of them including me
> could figure out what is the problem.
> Any advises??
> Cheers
> Debashish

help-login failed for MACHINE_NAME\IUSR_MACHINE_NAME

HI,
i have some problem,

one database 'SMS' is installed in sql server which instance is
BARODA\EMIS.

now i want to connect my web app to this database.
for that
my connectionstring is
--
conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=SSPI;data source=BARODA\EMIS;persist security info=True;initial catalog=SMS"
--

but when i run this error occur

--
login failed for 'MERIDIAN\IUSR_BARODA'
--

for that what should i do?
give any solution.

it's urgent.

thanks in advance.Hi,

This blog might help you:http://weblogs.asp.net/coltk/archive/2003/07/10/9920.aspx

Colt|||hey, colt

my problem,

i want to creat user in MSDE.

how to create user in MSDE?
how to create user in MSDE during app. installation?

give any solution.
it's urgent.

thanks in advance.

help-for copying database

hi,
i m new 4 sql server.
i create one app. in asp.net.

i create one database in sql server.
now,
i want to make setup for my app.
so,
i want copy database and put on c:/.../wwwroot/app folder.

how can i do this?

one more things,
i create database using enterprise manager.
i want to see my database file.
where it is stored?

somebody help me.

it's urgent.
thanks in advance.Not a wise move but if you insist, right-click on the database from Ent Mgr and then click on the Data Files tab, you will find the path to your datbase file there. Next, click on the Transaction Log tab on you will find the path to your transaction log there; these are the two files that make an SQL database.

help?

I need a little help to get me going.

I have built a web app in visual web developer and made and

inserted an sql db into the site with multiple .aspx pages.

It all compiles and seems great. Info from the db is displayed,however

when it comes to edit, insert or delete it bombs out

" incorrect syntax near'nvarchar' or on delete........'int'

some thing needs to be set to true...

All conection strings seem fine and test ok.

ps, whats the best way to to totally smash your dell laptop to pieces

and send it to pluto?

Have included error

Do you compose the commands on your own ? If yes, try to see what command(text) is actually executed against the database. if not, startup profiler to see the command executed.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

I don,t write the commands yet myself....all key events.

I will check and reply

Many thanks

|||Sure, come back if you have any questions.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Still got this glitch.

Could you have a look at the code for me.....the source code seems all to be ok with the target?

|||Seems that the statements posted do not contain any information about nvarchar, so I guess this is related to any trigger based on the tables. Have alook if there are any triggers which might get fired during the DML process.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi jens

thanks for your help recently.

I found out that i was trying to load data to my sql with the details view "tool" ................oops.

My test sql seems to be working like a train now. Also now discovering the full functionality

of sql and can see that im at the bottom of a large hill.

My next problem is publishing.

My hosting package has been upgraded to the version 2.0 asp.net runtime. and has sql enabled.

web dev.......copy function drops all the files into the server nicely and i can see them all.

The problem is it will not unwrap or show, and returns.........you do not have privaleges to view this htm.

All a bit strange to me but?

I have not touched any of the security controls in the config manager or code.

regards Richard uk