Group Access

Hi all
Is there a way to create a script of a database user to see all of the
objects that user has access to and what the access is for each object?
Thanks
Kevin
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi
You may want to look at the sysprotects table or possibly the
INFORMATION_SCHEMA.TABLE_PRIVILEGES view
John
"Kevin Hayward" wrote:
> Hi all
> Is there a way to create a script of a database user to see all of the
> objects that user has access to and what the access is for each object?
> Thanks
> Kevin
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>

gridview binding with sqlConnection objects...

Hello All, I am new to data access and

i have got the problem to display the data into the page by binding the gridview with sqlConnection, sqlCommand and sqlDataReader objects. The actually code is written as:

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!Page.IsPostBack)

{

SqlConnection myConnection;

SqlCommand myCommand;

SqlDataReader myReader;

myConnection =newSqlConnection();

myConnection.ConnectionString =ConfigurationManager.ConnectionStrings["LatteConnectionString"].ConnectionString;

myCommand =newSqlCommand();

myCommand.CommandText ="select * from AntiVirusVendors";myCommand.CommandType =CommandType.Text;

myCommand.Connection = myConnection;

myCommand.Connection.Open();

myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

GridView1.DataSource = myReader;

GridView1.DataBind();

myCommand.Dispose();

myConnection.Dispose();

}

}

and the GridView in html is listed as:

<div>

<asp:GridViewID="GridView1"runat="server">

</asp:GridView>

</div>

So the problem is --> there is nothing shown in the page, no errors no anything... just the empty page.

Any ideas would be appreciated. Thanks in advance!

Joe

sorry, the problem has been solved.