使用ExecuteSqlCommand和OracleParameter在c#中执行oracle授权

using Oracle.ManagedDataAccess.Client;

// 创建Oracle连接
using (OracleConnection connection = new OracleConnection(connectionString))
{
    connection.Open();

    // 创建OracleCommand对象
    using (OracleCommand command = connection.CreateCommand())
    {
        // 设置SQL语句
        command.CommandText = "GRANT SELECT ON table_name TO user_name";

        // 使用ExecuteSqlCommand方法执行SQL语句
        command.ExecuteNonQuery();
    }
}

using Oracle.ManagedDataAccess.Client;

// 创建Oracle连接
using (OracleConnection connection = new OracleConnection(connectionString))
{
    connection.Open();

    // 创建OracleCommand对象
    using (OracleCommand command = connection.CreateCommand())
    {
        // 设置SQL语句
        command.CommandText = "GRANT SELECT ON :table_name TO :user_name";

        // 添加参数
        command.Parameters.Add(new OracleParameter("table_name", OracleDbType.Varchar2)).Value = "table_name";
        command.Parameters.Add(new OracleParameter("user_name", OracleDbType.Varchar2)).Value = "user_name";

        // 使用ExecuteSqlCommand方法执行SQL语句
        command.ExecuteNonQuery();
    }
}