Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-09 : 08:46:00
|
| vijay writes "Dear Sir, Before I submit my querry I want to assure you that I have gone through FAQ and search our site. I have hosted a .NET asp application on a remote server. My ISP has provided me an IP address. Using this I am able to connect to the remote sever. I am able to create tables in the database on the remote server using query analyzer. Is there any way I can set security permissions for database objects on the remote server using query analyzer. On the remote server I cannot find Database Access tab on the table properties page.Thanking you,vijay" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-09 : 13:31:21
|
| You can use GRANT command in Query Analyzer to grant permissions to a user or a role in the database. You can also use Enterprise Manager to grant permissions.Tara Kizeraka tduggan |
 |
|
|
aero1
Starting Member
1 Post |
Posted - 2006-03-10 : 12:16:08
|
| Dear Tara, Thanks a lot for your solution.Regards,Vijay |
|
|
|
|
|
|
Database Permissions